topic Re: Excel CountIF on Qlik Sense and Pie Chart in Qlik Learning Discussions

Excel CountIF on Qlik Sense and Pie Chart

Fri, 15 Apr 2016 21:57:16 GMT

Hello evreyone,

First of all, thanks for your help.

I need to know how can I cont the number of lines that is under 95% for example. My column is following:

Calculated Availability (%)

0,12453%

0,12478%

0,12517%

0,12539%

2,05141%

2,05156%

5,09936%

5,09971%

5,12268%

5,18430%

9,24303%

9,24309%

9,28682%

9,34172%

15,48626%

17,86872%

17,86876%

Thanks,

swuehl — Fri, 15 Apr 2016 22:26:25 GMT

Try

=Count( If([Calculated Availabilty (%)] <= 0.95,[Calculated Availabilty (%)])

e.g in a kpi object expression.

Also a set expression might work:

=Count( {< [Calculated Availabilty (%)] = {"<=95,00000%"} >} [Calculated Availabilty (%)])

Sat, 16 Apr 2016 00:05:14 GMT

Thanks. It works.