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

[#1]

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

[sunny_talwar · Accepted solution]

May be this:

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

[#3]

This worked perfectly, thanks for the prompt response time!

[sunny_talwar]

No problem at all

Glad I was able to help.

Best,

Sunny