qliksense KPI#1 object

ilanbaruch — Sat, 16 Nov 2024 10:16:15 GMT

hi all,

i am using a couple of qliksense KPI#1 object in a dashboard, every one of them is with different set analysis calculation.

i notice that some of them dont respond to user selection, for example

one of the object calculate amount as below and retrieve the correct value

sum({$<PLATFORM={'Ios'},USAGETYPE={'Smartphone'}>}Amount)

but when i other platform (Android) value stay the same..

i would expect to see zero.

any ideas?

advanced thanks

Re: qliksense KPI#1 object

shraddha_g — Mon, 07 Nov 2016 09:08:25 GMT

you have hardcoded it as IOS.

Try,

if(getselectedcount(PLATFORM) <>0 or getselectedcount(USAGETYPE) <>0,

sum(Amount),sum({$<PLATFORM={'Ios'},USAGETYPE={'Smartphone'}>}Amount)

)