2 Replies Latest reply: Nov 13, 2017 3:48 AM by Andrea Gigliotti RSS

    sumif or countif greater than

    Isabel Encinas

      Hi Everyone,

       

      I'm just new in Qlik and I'm trying to count the number that is greater than 600s when I add the two dimensions:

       

      num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000))

      if the above total is greater than 600, then count as 1 if not 0

       

      this is not working.

      sum(IF([

      (((((sum([Aggr tTalkComplete])/sum([Aggr nHandle]))/1000) + (sum([Aggr tHeld])/sum([Aggr nHandle])/1000))]  <= 600) ,1,null())

       

      please help.. please please

       

      thanks for those who will answer