Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

arethaking
Contributor II

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

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: [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

1.png

2.png

3.png

2 Replies

Re: [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

MVP
MVP

Re: [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

1.png

2.png

3.png