Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
If(GetSelectedCount(Month) = 1, Sum({$<PERIOD = P(LAG1MONTH), BRAND = {'QLIK'}>} [SALES VALUE EUR]), 0)
May be this:
If(GetSelectedCount(Month) = 1, Sum({$<PERIOD = P(LAG1MONTH), BRAND = {'QLIK'}>} [SALES VALUE EUR]), 0)
This worked perfectly, thanks for the prompt response time!
No problem at all
Glad I was able to help.
Best,
Sunny