Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator III
Creator III

Conditional Sum comparison in set analysis Qlik sense

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.

 

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try something like:

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

View solution in original post

1 Reply
tresesco
MVP
MVP

Try something like:

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