Recently I talked about where to store variables once you’re ready to move your dashboard from development to live. Storing QlikView expressions into a data island will help ensure your dashboard remains accurate and will reduced development time further down the line by making changes a one step process.
This video covers storing expressions into a data island. A future shows how we can use this data island to create charts that a user can choose their own dimensions and expressions
Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!
https://www.youtube.com/watch?v=KTLXPx2f9wk
qlikcentral 
Pingback: Where to store your expressions in QlikView? | qlikcentral·
Superb. Thanks!
LikeLike
Richard,
how about this?:
Using the User Defined Function as Rob Wunderlich described on his blog to avoid the multiple programming of the only syntax?
I tested with a variable like this:
UDF = $(=only({1}Expression))
and then in in charts: $(UDF(sumValue)) and $(UDF(sumValue))/$(UDF(sumQuantity)) and $(UDF(Percentage))etc.
LikeLike
Pingback: User Controlled Charts in QlikView | qlikcentral·
Pingback: Automatically Create Point in Time Expressions | qlikcentral·
Very cool Richard. I followed this advice in a recent project with a bunch of engineering formulas – adjusting the formulas afterwards was a breeze. Thanks for another great tip.
I also used Michiel’s advice and created a UDF function – worked nicely.
LikeLike