Skip to main content

New to Qlik Sense

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

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 
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