6 Replies Latest reply: Sep 6, 2012 9:31 AM by Helen Pippard

# Count If > 360

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

• ###### Re: Count If > 360

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

• ###### Re: Count If > 360

Thank you! Works a treat!

• ###### Re: Count If > 360

Thank you! Works a treat!

• ###### Re: Count If > 360

Thank you!  Works a treat!

• ###### Re: Count If > 360

Thank you

• ###### Re: Count If > 360

two possibilities which should work:

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

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