# 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

## 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

## 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.