5 Replies Latest reply: Nov 23, 2017 5:05 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([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