Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jeckstein
Contributor

Why is KPI not taking selections into consideration?

Have a KPI that says

Sum({<Year={2018}>}Sales)

And a filter of Years (2016,2017,2018).

When I select Year 2017. I expect to see a 0 in the KPI but it still shows a number.

Can anyone explain.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Why is KPI not taking selections into consideration?

The set expression overrides your user selection. This is the normal/default behaviour. You can override this to create an intersection between the selection and the year in the set expression, like this

     Sum({<Year *= {2018}>}Sales)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Why is KPI not taking selections into consideration?

The set expression overrides your user selection. This is the normal/default behaviour. You can override this to create an intersection between the selection and the year in the set expression, like this

     Sum({<Year *= {2018}>}Sales)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Re: Why is KPI not taking selections into consideration?

Read more on this topic here:

Implicit Set Operators

Community Browser