Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for
Did you mean:
Creator II

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

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

1 Solution

Accepted Solutions
MVP

[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

2 Replies
MVP

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

[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

Community Browser