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

    Count If > 360

    Helen Pippard

        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