Conditional Sum comparison in set analysis Qlik sense

[UserID2626]

Hi,

how to compare two measures in set analysis?

Need to find count(Id) who's sum(A)> Sum(B).

Count({<sum(A)> Sum(B)>}ID) //for each ID need to compare sum(A) with Sum(B)  & need to take count for each day.

[tresesco · Accepted solution]

Try something like:

Count(Distinct {<ID={"=sum(A)> Sum(B)" } >} ID)