How to Count Distinct When Two Conditions Are Met

[Sonja_Bauernfeind]

This can be accomplished with Set Analysis.

If there are three columns in the app named: A B and C and we want to count the distinct values of C when certain values exist for A and B, the syntax for this would be

count({<A={'ValueA'},B={'ValueB'}>}distinct C)

This will count the distinct values in Column named C when the field values for Column A and B equal ValueA and ValueB, respectively.

Environment:

Qlik Sense Business 
Qlik Sense Enterprise on Windows 
Qlik Cloud 
QlikView 

Related Content:

Set analysis and set expressions