Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to set KPI chart to = 0 when no month filter is selected?

Hi all,

I'd like to know how to set a KPI chart to equal 0 when a month dimension filter is not selected, and also when multiple months are selected (basically, only show a value when one and only one month is selected, otherwise default to "0"). What would a generic expression modifier look like that would accomplish this?

Here is the current sample expression:

Sum({$<PERIOD = P(LAG1MONTH), BRAND = {'QLIK'}>} [SALES VALUE EUR])

Thanks,

Kendrick

1 Solution

Accepted Solutions
MVP
MVP

Re: How to set KPI chart to = 0 when no month filter is selected?

May be this:

If(GetSelectedCount(Month) = 1, Sum({$<PERIOD = P(LAG1MONTH), BRAND = {'QLIK'}>} [SALES VALUE EUR]), 0)

3 Replies
MVP
MVP

Re: How to set KPI chart to = 0 when no month filter is selected?

May be this:

If(GetSelectedCount(Month) = 1, Sum({$<PERIOD = P(LAG1MONTH), BRAND = {'QLIK'}>} [SALES VALUE EUR]), 0)

Not applicable

Re: How to set KPI chart to = 0 when no month filter is selected?

This worked perfectly, thanks for the prompt response time!

MVP
MVP

Re: How to set KPI chart to = 0 when no month filter is selected?

No problem at all

Glad I was able to help.

Best,

Sunny

Community Browser