Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
helen_pip
Contributor II

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

6 Replies

Re: Count If > 360

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


talk is cheap, supply exceeds demand
s_kunte23
Contributor III

Re: Count If > 360

two possibilities which should work:

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

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

helen_pip
Contributor II

Re: Count If > 360

Thank you! Works a treat!

helen_pip
Contributor II

Re: Count If > 360

Thank you! Works a treat!

helen_pip
Contributor II

Re: Count If > 360

Thank you!  Works a treat!

helen_pip
Contributor II

Re: Count If > 360

Thank you

Community Browser