# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## how to count?

Hi,

i want to count this -

(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2', Mission))

Regards

Tags (3)
5 Replies
Contributor III

## Re: how to count?

Hello Agrim,

a normal count around this does not work?

count(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2', Mission))

Contributor II

## Re: how to count?

obviously not my friend, i tried a lot

Honored Contributor II

## Re: how to count?

Hi,

Can you share the mock data and expected output in excel format, tks

Honored Contributor II

## Re: how to count?

where are you using the expression btw?

i would try this first

=sum(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2',1,0)

or

=sum(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) =2,1,0)

try this too

count (if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) =2, Mission))

Learning never stops.
Contributor III

## Re: how to count?

He can not count because you have a else clause:

I think

count(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2'))

for example should work.