topic Re: '$' - IDENTIFIER (SET ANALYSIS) in QlikView

'$' - IDENTIFIER (SET ANALYSIS)

kamal_sanguri — Wed, 30 Sep 2015 10:17:08 GMT

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}

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

Re: '$' - IDENTIFIER (SET ANALYSIS)

Gysbert_Wassenaar — Thu, 01 Oct 2015 05:51:58 GMT

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

Re: '$' - IDENTIFIER (SET ANALYSIS)

jagan — Thu, 01 Oct 2015 06:12:51 GMT

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)

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

Regards,

Jagan.

Re: '$' - IDENTIFIER (SET ANALYSIS)

kamal_sanguri — Thu, 01 Oct 2015 08:38:26 GMT

Thanks!!

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

Regards,

-Kamal