Solved: Re: Set Expression - Qlik Community

vikasgupta · ‎2013-08-21

Hi Everyone

Can anyone explain this set expression

ID_TYPE=$::ID_TYPE,

Thanks

Vikas

Report Inappropriate Content · ‎2013-08-21

This is used when you have Alternate State(s).

To apply or use the selection(s) from one state in another state, you would use such syntax.

e.g. sum({[State 1]<ID_TYPE=$::ID_TYPE>} Sales)

View solution in original post

vikasmahajan · ‎2013-08-21

Hii

Normally :: is used with comprehensive analysis meaning of this expression is ID type is = selected ID type $ is used for selection.

Hope this help you.

Vikas Mahajan

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasgupta · ‎2013-08-21

Hi Vikas

Thanks for reply !!

Please let me know If i am correct then this expression used for just fetching current selection .

Thanks

Vikas

vikasmahajan · ‎2013-08-21

Yes , $ identifier is for current selections only.

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-08-21

:: is a scope resolution

er_mohit · ‎2013-08-21

Go to this link

Qlikview: Set Analysis | Hyunku's Blog

tresesco · ‎2013-08-21

I guess, this is being used in a case of alternate state. $:: is to use the selection in the default state filters.

Report Inappropriate Content · ‎2013-08-21

hi Vikasgupta

in your code
ID_TYPE=$::ID_TYPE,

here--

:: stands for Scope Operator also known as default state scope operator.

basically this uses in set analysis with $ (current selection) sign

Report Inappropriate Content · ‎2013-08-21

This is used when you have Alternate State(s).

To apply or use the selection(s) from one state in another state, you would use such syntax.

e.g. sum({[State 1]<ID_TYPE=$::ID_TYPE>} Sales)