Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamal_sanguri
Specialist
Specialist

'$' - IDENTIFIER (SET ANALYSIS)

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
jagan
Luminary Alumni
Luminary Alumni

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
Specialist
Specialist
Author

Thanks!!

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

Regards,

-Kamal