Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2022 3:21:58 PM
Feb 12, 2019 11:19:54 AM
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.
Qlik Sense Business
Qlik Sense Enterprise on Windows
Qlik Cloud
QlikView