topic Re: Set Expression in QlikView

Set Expression

vikasgupta — Wed, 21 Aug 2013 07:48:46 GMT

Hi Everyone

Can anyone explain this set expression

ID_TYPE=$::ID_TYPE,

Thanks

Vikas

vikasmahajan — Wed, 21 Aug 2013 07:51:36 GMT

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

vikasgupta — Wed, 21 Aug 2013 07:56:39 GMT

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 — Wed, 21 Aug 2013 09:04:20 GMT

Yes , $ identifier is for current selections only.

Wed, 21 Aug 2013 09:19:46 GMT

:: is a scope resolution

er_mohit — Wed, 21 Aug 2013 09:39:05 GMT

Go to this link

tresB — Wed, 21 Aug 2013 09:39:15 GMT

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

Wed, 21 Aug 2013 09:43:17 GMT

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

Wed, 21 Aug 2013 09:54:01 GMT

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)