topic distinct count in QlikView

topic distinct count in QlikView https://community.qlik.com/t5/QlikView/distinct-count/m-p/188137#M51514 <HTML><HEAD></HEAD><BODY><P></P><P>count({$<MOD = {'X4','X5','X6','X3','X7'},CPT -={'99499'}>}[MRN])</P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><BR /><BR /> <P>I have the above formula but its not distinct. The MRN count is adding dups as well. How can i make it distinct.</P><P>Thanks</P><P>Krishan</P></BODY></HTML> Fri, 03 Sep 2010 17:48:09 GMT 2010-09-03T17:48:09Z distinct count https://community.qlik.com/t5/QlikView/distinct-count/m-p/188137#M51514 <HTML><HEAD></HEAD><BODY><P></P><P>count({$<MOD = {'X4','X5','X6','X3','X7'},CPT -={'99499'}>}[MRN])</P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><BR /><BR /> <P>I have the above formula but its not distinct. The MRN count is adding dups as well. How can i make it distinct.</P><P>Thanks</P><P>Krishan</P></BODY></HTML> Fri, 03 Sep 2010 17:48:09 GMT https://community.qlik.com/t5/QlikView/distinct-count/m-p/188137#M51514 2010-09-03T17:48:09Z distinct count https://community.qlik.com/t5/QlikView/distinct-count/m-p/188138#M51515 <HTML><HEAD></HEAD><BODY><P>Just add the word "distinct": count({your set} distinct MRN)</P><P>Regards,</P></BODY></HTML> Fri, 03 Sep 2010 17:50:59 GMT https://community.qlik.com/t5/QlikView/distinct-count/m-p/188138#M51515 vgutkovsky 2010-09-03T17:50:59Z