Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Set Analysis with current selection

Hi,

I´m using a KPI expression for a chart like

Sum( {<Status={'A', 'B'}>} CountOffers)

The same set analysis expression is used in all chart objects of the sheet for other KPIs.

If a user selects status = A this selection should be used in the KPI expression. But this is not the case when I use the expression above, because the selection on status is fixed to A+B, disregarding the current selection of the user.

What is the easiest way to solve this?

KR, Thomas

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

I think I have it

Sum( {<Status*={'A', 'B'}>} CountOffers)

View solution in original post

5 Replies
Highlighted
Champion III
Champion III

May be this?

Sum( {$<Status={'A', 'B'}>} CountOffers)

Highlighted
Partner
Partner

I think I have it

Sum( {<Status*={'A', 'B'}>} CountOffers)

View solution in original post

Highlighted
Partner
Partner

This expression is the same as mine, just with a dollar sign which is default in case not specified.

Highlighted
Partner
Partner

In the QlikView for Developers book I found a description:

*=: This operator is used to define the corresponding field values based

on the intersection between what the user has selected and the values we

specify. That is, the resulting record set will be the values that "intersect" or

are present in both the user's selection and the values we explicitly define in

our element list.

Highlighted

You can also check this link out

Implicit Set Operators