topic Expression help in QlikView https://community.qlik.com/t5/QlikView/Expression-help/m-p/314017#M115930 <HTML><HEAD></HEAD><BODY><P>Can anyone please let me know what this code is doing? Thanks in advance for the help!</P><P></P><P><SPAN style="color: #000000; font-family: verdana, sans-serif; text-align: -webkit-auto; font-size: small;">Count(Distinct {1&lt;Approximate_Flag_1 = {0}, No_Map_Flag_2 = {0}, Combination_Flag_3 = {0}, Scenario_Flag_4 = {0}, Choice_Flag_5 = {0}&gt;} MCG_Code)/Count(Distinct Total{1&lt; Approximate_Flag_1={"*"}&gt;} <SPAN style="color: #000000; font-family: verdana, sans-serif; text-align: -webkit-auto; font-size: small;">MCG_Code</SPAN>)</SPAN></P></BODY></HTML> Fri, 27 Jan 2012 17:54:37 GMT 2012-01-27T17:54:37Z Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/314017#M115930 <HTML><HEAD></HEAD><BODY><P>Can anyone please let me know what this code is doing? Thanks in advance for the help!</P><P></P><P><SPAN style="color: #000000; font-family: verdana, sans-serif; text-align: -webkit-auto; font-size: small;">Count(Distinct {1&lt;Approximate_Flag_1 = {0}, No_Map_Flag_2 = {0}, Combination_Flag_3 = {0}, Scenario_Flag_4 = {0}, Choice_Flag_5 = {0}&gt;} MCG_Code)/Count(Distinct Total{1&lt; Approximate_Flag_1={"*"}&gt;} <SPAN style="color: #000000; font-family: verdana, sans-serif; text-align: -webkit-auto; font-size: small;">MCG_Code</SPAN>)</SPAN></P></BODY></HTML> Fri, 27 Jan 2012 17:54:37 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/314017#M115930 2012-01-27T17:54:37Z Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/314018#M115931 <HTML><HEAD></HEAD><BODY><P>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).&nbsp; This expression ignores all user selections.</P><P></P><P>Karl</P></BODY></HTML> Fri, 27 Jan 2012 18:01:37 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/314018#M115931 pover 2012-01-27T18:01:37Z