What does the "::" function do in this expression?

[#1]

Hi all,

I have an expression that is like below:

sum({State1<Year=$::Year>}LineSalesAmount)

What does the "::" part in the expression do?

[petter]

Hi Michael,

Have a look here and you will get an explanation:

     QlikView Syntax (specifically Alternate States):

     http://www.qlikcommunity.com/thread/80385

[Anonymous]

it means that the selections made to Year from the other states are carried through to this state.

[Anonymous]

When you work with Comparative Analysis you often create some list boxes to make different selections, but you may want to impact other fields from the data model when selecting some values without having to create additional list boxes for those fields. Some fields you may want to avoid dupplicating are date fields like in your example, and notation for these fields is:

AggregationFunction({[Alternate State] <[Field 1]=$::[Field 1], [Field 2]=$::[Field 2]>} KPI).

Hope this helps you to understand better the function of $::

Regards.

Oscar

[#5]

Thanks guys, so if I made selections in another sheet or another Year field box in my application - the "::" would carry it through to my expressions where I defined them?

[Anonymous]

that is correct. this helps when you have "global" filters that need to affect all objects irrespective of states.

[#7]

Thank you jsaradhi