Excel CountIF on Qlik Sense and Pie Chart

[#1]

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%
2,05156%
5,09936%
5,09971%
5,12268%
5,18430%
9,24303%
9,24309%
9,28682%
9,34172%
15,48626%
17,86872%
17,86872%
17,86876% Thanks,

[swuehl · Accepted solution]

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 (%)])

[#3]

Thanks. It works.