Hi,
I am using Qlik Sense 3.2.4 and I have an issue with a sum If
| Client Id | Product Category | Sales | Limite
| If(sum(Sales) >= max(Limite),1,0) |
|---|
| 1 | Category 1 | 7 | 7 | 1 |
| 2 | Category 1 | 6 | 7 | 0 |
| 3 | Category 1 | 7 | 7 | 1 |
| 4 | Category 2 | 5 | 5 | 1 |
| 5 | Category 2 | 3 | 5 | 0 |
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
