'$' - IDENTIFIER (SET ANALYSIS)

[kamal_sanguri]

Hi Experts,

As far as I know, having $ in Set Analysis makes no difference even if we remove it or Does it?

for ex:

sum({<YEAR={'2015'}> Sales}

          OR

sum({$<YEAR={'2015'}> Sales}

I was using a similar expression with $ sign and it was working fine. However, all of a sudden, it started behaving unexpectedly (Instead of getting Total of Sales for 2015, it was giving 0). Just for a try, I removed the '$' (Identifier) and correct values popped up.

Any Idea on this...?

Thanks,

-Kamal

[Gysbert_Wassenaar · Accepted solution]

It matters if you're using alternate states. See this blog post: Set Analysis & Alternate States – Quick Tip » The Qlik Board!

[jagan]

HI,

In normal state both the expressions should work as same, $ is an optional one, so both the expressions will give the same values if you are not using any alternate states.

sum({<YEAR={'2015'}> Sales)

          OR

sum({$<YEAR={'2015'}> Sales)

Regards,

Jagan.

[kamal_sanguri]

Thanks!!

Yes, I am using Alternate state. It's a good piece of info which you shared. I will explore it more.

Regards,

-Kamal