# New to QlikView

Discussion board where members can get started with QlikView.

Contributor II

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

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

Tags (1)
1 Solution

Accepted Solutions
MVP

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

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

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

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

## 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

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

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

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