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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression help

Can anyone please let me know what this code is doing? Thanks in advance for the help!

Count(Distinct {1<Approximate_Flag_1 = {0}, No_Map_Flag_2 = {0}, Combination_Flag_3 = {0}, Scenario_Flag_4 = {0}, Choice_Flag_5 = {0}>} MCG_Code)/Count(Distinct Total{1< Approximate_Flag_1={"*"}>} MCG_Code)

1 Reply
pover
Partner - Master
Partner - Master

It counts the number of distinct MCG_Code that have the Approximate_Flag_1, No_Map_Flag, Combination_Flag_3, Scenario_Flag_4, Choice_Flag_5 with the value 0 and divides it with a count of the number of distinct MC_Code with whatever Approximate_Flag_1 (The "*" might exclude null values).  This expression ignores all user selections.

Karl