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

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

Mon, 20 Jul 2015 16:20:01 GMT

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

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

sunny_talwar — Mon, 20 Jul 2015 16:23:32 GMT

May be this:

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

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

Mon, 20 Jul 2015 16:28:57 GMT

This worked perfectly, thanks for the prompt response time!

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

sunny_talwar — Mon, 20 Jul 2015 16:30:17 GMT

No problem at all

Glad I was able to help.

Best,

Sunny