Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

agrimroquette
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

5 Replies
Ralf_Heukäufer
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))

agrimroquette
Contributor II

Re: how to count?

obviously not my friend, i tried a lot

devarasu07
Honored Contributor II

Re: how to count?

Hi,

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

pradosh_thakur
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.
Ralf_Heukäufer
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.

Community Browser