topic Re: Count If > 360 in QlikView

Count If > 360

helen_pip — Thu, 06 Sep 2012 13:14:45 GMT

Hello

I am very new to Qlikview...as in I have only really started using it today

I have searched for an already existing response and have tried a few techniques but cannot find a solution as of yet

I want to write a count if expression for when Total Waits is greater than 360

The syntax I have at present is:

COUNT(IF([Total Wait]

>360,1,0))

I am not getting the result I need. I want to evaluate every row to see if the TotalWait is greater than 360, then count them

Is anyone able to help?

Kind Regards

Helen

Gysbert_Wassenaar — Thu, 06 Sep 2012 13:23:03 GMT

Try SUM(IF([Total Wait]>360,1,0))

Anonymous — Thu, 06 Sep 2012 13:25:46 GMT

two possibilities which should work:

if([Total Wait] > 360, count([Total Wait])) or

sum(if([Total Wait] > 360, 1,0))

helen_pip — Thu, 06 Sep 2012 13:29:17 GMT

Thank you! Works a treat!

helen_pip — Thu, 06 Sep 2012 13:29:24 GMT

Thank you! Works a treat!

helen_pip — Thu, 06 Sep 2012 13:30:22 GMT

Thank you! Works a treat!

helen_pip — Thu, 06 Sep 2012 13:31:23 GMT

Thank you