Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thkarner
Contributor III

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

Tags (1)
1 Solution

Accepted Solutions
thkarner
Contributor III

Re: Set Analysis with current selection

I think I have it

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

5 Replies
sureshqv
Esteemed Contributor III

Re: Set Analysis with current selection

May be this?

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

thkarner
Contributor III

Re: Set Analysis with current selection

I think I have it

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

thkarner
Contributor III

Re: Set Analysis with current selection

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

thkarner
Contributor III

Re: Set Analysis with current selection

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.

MVP
MVP

Re: Set Analysis with current selection

You can also check this link out

Implicit Set Operators