Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
DMG
Contributor III
Contributor III

Sum if two different values exist in same column for same id

I've a table of data where multiple rows exist for the same item, e.g.

Device     Value

1                 A
1                 B
2                 A
3                 A
3                 B

I want to sum the total number of situations where a unique device has rows of data that contain both A and B, so the result to the above data would be 2 

0 Replies