Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you have hardcoded it as IOS.
Try,
if(getselectedcount(PLATFORM) <>0 or getselectedcount(USAGETYPE) <>0,
sum(Amount),sum({$<PLATFORM={'Ios'},USAGETYPE={'Smartphone'}>}Amount)
)