Discussion board where members can get started with Qlik Sense.
I have this KPI formula
(IF(count(if([0.CFP/HH] ='HH',1,0)) > 1 ,num(sum([19.Not affordable]),'#,##0%'), 'No Answer'))
Right now it shows 16 without percentage like "Num" function" has any effect, but when I place it outside the if, it works, I cannot do this because the answer might be "No answer" or number 12%
What is missing here to make it work the way I need.
This little test seems to work for me
=If(1=1, Num(1, '#0%'), 'No Answer') -> 100%
=If(2=1, Num(1, '#0%'), 'No Answer') -> No Answer