topic Re: What does the "::" function do in this expression? in QlikView

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

Mon, 23 Jun 2014 16:18:45 GMT

Hi all,

I have an expression that is like below:

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

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

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

petter — Mon, 23 Jun 2014 16:35:40 GMT

Hi Michael,

Have a look here and you will get an explanation:

QlikView Syntax (specifically Alternate States):

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

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

Anonymous — Mon, 23 Jun 2014 16:46:27 GMT

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

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

Anonymous — Mon, 23 Jun 2014 17:18:15 GMT

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

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

Mon, 23 Jun 2014 18:14:39 GMT

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?

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

Anonymous — Mon, 23 Jun 2014 18:18:17 GMT

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

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

Mon, 23 Jun 2014 18:24:42 GMT

Thank you jsaradhi