qliksense KPI#1 object

[ilanbaruch]

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

[shraddha_g]

you have hardcoded it as IOS.

Try,

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

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

)