Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Excel CountIF on Qlik Sense and Pie Chart

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,

1 Solution

Accepted Solutions
MVP
MVP

Re: Excel CountIF on Qlik Sense and Pie Chart

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

2 Replies
MVP
MVP

Re: Excel CountIF on Qlik Sense and Pie Chart

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

Not applicable

Re: Excel CountIF on Qlik Sense and Pie Chart

Thanks. It works.

Community Browser