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

    Sum if issue

    Nicolas Le Roux

      Hi,

       

      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,

      Nicolas