Count If > 360

[helen_pip]

  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]

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

[Anonymous]

two possibilities which should work:

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

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

[helen_pip]

Thank you! Works a treat!

[helen_pip]

Thank you! Works a treat!

[helen_pip]

Thank you!  Works a treat!

[helen_pip]

Thank you