Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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!
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.
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
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.