$:: in set analysis

[simsa]

Hi Qlik Community,

I Wish to have clarity regarding usage of $:: in Qlik Sense

SUM({1<A=$::B>}X)

What will the above statement return?

Sum of all X only dependent on selection on B which is matching to A data?

What if currently there is no selection made in B column?

[Anil_Babu_Samineni]

Just a thought, It's good if you can get hand from your data. Because, this can help for you to understand. FRom there if any questions, you can post.

[Vegar]

It will give you the sum of X where A is equal to any selection in field B. 

If you rather want A to be equal to any value in B then try SUM({1<A=P(B)>}X)

[sidhiq91]

@simsa  It will give you sum of X for any selection made on B that is Equal to A.

If no selection is made then the answer is zero.