topic CountIF / CountIF and display Percentage in QlikView

CountIF / CountIF and display Percentage

nigelapt — Fri, 22 Oct 2021 14:17:47 GMT

Hi Folks

I am trying to display the 0% value from this expression:

=NUM(Count(IF([DWH Automated Recovery]='Yes',0))/NUM(Count(IF([DWH Severity]='Critical',0)),'0%'))*100

The calculation is

1,042,586 / 1,182,368 = 88%

However no matter what format I apply I still get 88.17779236244553

Be grateful if anyone could advise what I am doing wrong.

Thanks

Nigel

MarcoWedel — Sun, 24 Oct 2021 16:58:28 GMT

Hi,

I think one solution to your format issue could be

=NUM(Count(IF([DWH Automated Recovery]='Yes',0))/Count(IF([DWH Severity]='Critical',0)),'0%')

Besides this you could also replace your If() function with a set expression.

Hope this helps

Marco

nigelapt — Fri, 18 Feb 2022 10:40:10 GMT

Marco, thanks very much for the solution. Apologies for the late reply. I meant to acknowledge this sooner. Nigel