Using variable in an Expression vs. by itself

Anonymous — Thu, 09 Feb 2017 20:03:46 GMT

variable1 Definition:
Fractile({<NumberField=>} if(TimeField < vVariable2, TimeField), vVariable3)

If it's used by itself as an expression, as one of the columns of a Straight Chart like:
=$(vVariable1)

It displays values correctly. Each row has a distinct value.

But, when this variable is used inside an expression in the same chart; the expression doesn't work, for example, the expression:

=Avg({<NumberField=, TimeField={'<$(=vVariable1)'}>} TimeField)

Re: Using variable in an Expression vs. by itself

sunny_talwar — Thu, 09 Feb 2017 20:13:15 GMT

When you use this this as set analysis the variable is evaluated once per chart. What that means is that if you use this variable in a text box object, whatever value you get will be used across the chart. Set analysis doesn't get evaluated on each dimension. The work around this is to use Aggr() function.

topic Re: Using variable in an Expression vs. by itself in QlikView

Using variable in an Expression vs. by itself

Re: Using variable in an Expression vs. by itself