topic Re: Question about $,$1 values in set analysis in QlikView

Question about $,$1 values in set analysis

Thu, 12 Jul 2012 21:12:50 GMT

Hi,

Can somebody explain how does $,$1 impacts set analysis expression.

For e.g. I created set analysis to count only 'Fruit' produce from inventory and it worked well for me.

= Count({$<[Type]={Fruit}>} Type)

But this raised a question in my mind, what does $1,$2 will indicate instead of only adding $.

Can somebody please elaborate.

Re: Question about $,$1 values in set analysis

CELAMBARASAN — Thu, 12 Jul 2012 21:16:39 GMT

sum( {$} Sales )
returns sales for the current selection, i.e. the same as sum(Sales).

sum( {$1} Sales )
returns sales for the previous selection.

sum( {$_2} Sales )
returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations.

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.