sumif or countif greater than

[Anonymous]

Hi Everyone,

I'm just new in Qlik and I'm trying to count the number that is greater than 600s when I add the two dimensions:

num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000))

if the above total is greater than 600, then count as 1 if not 0

this is not working.

sum(IF([

(((((sum([Aggr tTalkComplete])/sum([Aggr nHandle]))/1000) + (sum([Aggr tHeld])/sum([Aggr nHandle])/1000))]  <= 600) ,1,null())

please help.. please please

thanks for those who will answer

[swuehl]

What are the grouping entities you want to apply the if() condition to, then aggregate the result over all entities?

In other words, describe the context you are using this expression in.

[agigliotti · Accepted solution]

in your chart object use the below measure expression:

=sum(

aggr(

If( sum([Aggr tTalkComplete]+[Aggr tHeld])/1000 > 600, 1, 0 )

, your_dim1, your_dim2 )

)

[Anonymous]

Hi andrea,

what should I put on "your_dim1 and your_dim2?

[Anonymous]

I just get it!! super Thanks Andrea!!!

[agigliotti]

Hi Isabel,

could you please mark "Correct Answer" my reply above if it solved your problem?

Thanks

Andrea