topic Re: [Status]*={'A','B'} in QlikView

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

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Sun, 24 Jul 2016 02:23:15 GMT

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

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

maxgro — Sun, 24 Jul 2016 06:15:14 GMT

[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