Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the meaning of this expression [Status]*={'A','B'}
[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
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
[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