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.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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