[Status]*={'A','B'}

[arethaking]

What is the meaning of this expression [Status]*={'A','B'}

[sunny_talwar]

Lets break this expression down...

Status = {'A', 'B'} (without *)

Means that show status A and B regardless of any selection made in Status. But if you add the *, it means that show A and B when nothing is selected, but once you select something it will filter based on what you select.

Ex. If A and C is selected, only A will be shown because it is the intersection between what is selected and what is specified in your set analysis

Ex 2 if C and D are selected, nothing will be shown because there is nothing common between what is selected and what is within the set analysis.

Does this make sense?

Best,

Sunny

[maxgro · Accepted solution]

[Status]*={'A','B'} is a short equivalent of

Status=Status * {'A','B'}

If you look at the online help (F1) in Qlik:

In set analysis * is the Intersection operator.

This binary operation returns a set consisting of the records that belong to both of the two set operands

sum( {$<Status *= {'A','B'} >} Sales )

returns the sales for the current selection, but only for the intersection of currently selected status and the status A, B