Sum if issue

[nlr-biin_soluti]

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

[nlr-biin_soluti · Accepted solution]

I just found how to do it.

Sum(Total if(aggr(sum(Sales, [Client Id]) >= aggr(Max(Limite), [Client Id]), 1, 0))

Nicolas