Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Formatting text vs number

Hi Guys,

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.

Thanks, -Hanna

Tags (1)
1 Reply
Not applicable

Re: Formatting text vs number

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