1 Reply Latest reply: Jul 10, 2017 5:37 PM by Nicolas Le Roux RSS

    Sum if issue

    Nicolas Le Roux



      I am using Qlik Sense 3.2.4 and I have an issue with a sum If


      Client IdProduct CategorySalesLimite
      If(sum(Sales) >= max(Limite),1,0)
      1Category 1771
      2Category 1670
      3Category 1771
      4Category 2551
      5Category 2350


      I would like to calculate the total of the last column by category but I can not figure out how to do this.

      Category 1 = 2

      Category 2 = 1


      Is there anyone that could help me?


      Thanks in advance for your help.


      Best regards,