topic Re: Does using a leading equal sign in variable expressions need to be paired with the type of chart the variable will be placed in? in QlikView

Does using a leading equal sign in variable expressions need to be paired with the type of chart the variable will be placed in?

evan_kurowski — Sat, 22 Nov 2014 16:59:04 GMT

Hello All,

I am examining the behavior of expressions when they contain leading equal signs. In the attached example, the behavior seems clear enough.

A leading equal sign in the variable will cause the expression to evaluate once at the base level of the application. It looks at the current selections, passes them to the expression and then the variable becomes a constant when used within the context of the bar chart object.
A variable without a leading equal sign, when used in the bar chart expression, will evaluate a result per dimension.

Seems clear enough. However, I am now thinking back to examples where I saw variables fed into expressions in charts where there was no $() wrapping of the variable. I could've sworn I've seen examples where this was done in charts where there was a dimension. Except now I'm not so sure.

Does a variable without a leading '=' equal sign and not wrapped in $() work the same way in a chart expression as a variable that does not have these? Does it matter which type of chart the variable is being used in?

Has it always worked this way? Was there ever a time that QlikView could be fed a variable with a leading equal sign, not wrapped in dollar-sign expansion, and it produced a result per dimension?

Re: Does using a leading equal sign in variable expressions need to be paired with the type of chart the variable will be placed in?

Sat, 22 Nov 2014 18:00:15 GMT

Very interesting question. If I were you, I'd ask Henric Cronström to answer this.

Re: Does using a leading equal sign in variable expressions need to be paired with the type of chart the variable will be placed in?

Anonymous — Sat, 22 Nov 2014 18:00:26 GMT

This Blog post by Henric Cronström gives a very good explanation

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions

Re: Does using a leading equal sign in variable expressions need to be paired with the type of chart the variable will be placed in?

maxgro — Sat, 22 Nov 2014 18:11:46 GMT

and also

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables