Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
juntiporn_k
Partner - Contributor II
Partner - Contributor II

Having $ and no $ defined in set scope

What is the difference between having $ and no $ defined in set scope

Example:

sum({$<Year=2016>} Value)

and

sum({<Year=2016>} Value)

I can see that the results are the same with regarding the selections of other dimensions (not included Year).

Do you have any other case to explain in case of different results?

5 Replies
sunny_talwar

There is no difference. It essentially means the same things. The use of $ explicitly tells that the expression needs to filter based on selections in inherited state.

For more help on set analysis, the attached document is a good source to refer.

Gysbert_Wassenaar

Usually there's no difference. But there can be when you use alternate states. See this blog post for more information: Set Analysis & Alternate States – Quick Tip » The Qlik Board!


talk is cheap, supply exceeds demand
juntiporn_k
Partner - Contributor II
Partner - Contributor II
Author

Hi Sunny,

Firstly, many thanks for your help clarify my questions even other questions as well.

and thanks for such a good stuff on the attached file.

According to Inherited State you mentioned, I nearly understand it but not completely.

Pls kindly explain more about that.

sunny_talwar

So QlikView allows you to do comparison using different states. Inherited and Default states are the states that you use initially and then have the ability to add more states as you may need. Please have a look at this post of Qlik Community which helps determine the difference between Inherited vs. Default vs. Alternate State: Qlikview-Alternate States Fundamental-Inheritted vs Default

Anonymous
Not applicable

I have just checked the QV Desktop Help ( QV12 SR8) and what it says is, I think, incorrect :

$ Represents the records of the current selection.

The set expression {$} is thus the equivalent of not stating a set expression.

My understanding is that $ is the Default state, as in it ignores any Alternate State inherited from a parent object.

Whereas nothing means if will inherit the state of its parent.