Set Analysis with current selection

[thkarner]

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

[Chanty4u]

May be this?

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

[thkarner · Accepted solution]

I think I have it

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

[thkarner]

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

[thkarner]

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.

[sunny_talwar]

You can also check this link out

Implicit Set Operators