Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thkarner
Partner - Creator III
Partner - Creator 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

1 Solution

Accepted Solutions
thkarner
Partner - Creator III
Partner - Creator III
Author

I think I have it

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

View solution in original post

5 Replies
Chanty4u
MVP
MVP

May be this?

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

thkarner
Partner - Creator III
Partner - Creator III
Author

I think I have it

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

thkarner
Partner - Creator III
Partner - Creator III
Author

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

thkarner
Partner - Creator III
Partner - Creator III
Author

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