Discussion board where members can get started with Qlik Sense.
I have the following measure in extension Simple KPI:
I defined the number formatting as measure expression , but the percent doesn't work
If i just write num(count(distinct APP_ID)/100,'#,##0%') - not in if conditional - it works..
Could you please advise?
What do you get when you use it within the if condition and outside of if condition?
With if condition - 27
Without if condition - 27 %
Are you sure the Type = 'Percent'?
Yes, even I write :
if(1=1, num(count( APP_ID),'#,##0%'))
it doesn't work..
Have you tried with Standard KPI Object and not your extension ?
It worked in normal KPI Object for me , if it didn't work in extension , there seems to be some issue with Extension standard defaulting of the Object
Thank you for your help!
It's work for me in the standart KPI but I need background to the object and I don't have it in the standard KPI...
Can you try calculating the count()/100 and concatenating % , May be that would help ?
I have tried this option but it didn't work...
Looks like a bug to me, try using variable for '#,##0%', something like $(vPercentFormat).