topic Re: Distinct Records in Chart in QlikView https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841477#M531940 <HTML><HEAD></HEAD><BODY><P>Use this expr</P><P>=Count(DISTINCT MAR)</P></BODY></HTML> Tue, 12 May 2015 09:46:40 GMT anbu1984 2015-05-12T09:46:40Z Distinct Records in Chart https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841475#M531938 <HTML><HEAD></HEAD><BODY><P>Hi Friends ,</P><P></P><P>I have a requirement</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 306px;"><TBODY><TR><TD height="19" width="72">Country</TD><TD width="79">LIST TYPE</TD><TD width="155">MAR</TD></TR><TR><TD height="19">AE</TD><TD>BIC</TD><TD>BMCADR1</TD></TR><TR><TD height="19">AE</TD><TD>CIL</TD><TD>BMCADR1</TD></TR><TR><TD height="19">AE</TD><TD>BIC</TD><TD>BMCADR3</TD></TR><TR><TD height="19">AE</TD><TD>CIL</TD><TD>BMCADR4</TD></TR><TR><TD height="19">AU</TD><TD>BIC</TD><TD>BMCADR5</TD></TR><TR><TD height="19">AU</TD><TD>CIL</TD><TD>BMCADR6</TD></TR><TR><TD height="19">AU</TD><TD>AUM</TD><TD>BMCADR6</TD></TR><TR><TD height="19">IND</TD><TD>AUM</TD><TD>BMCADR8</TD></TR><TR><TD height="19">IND</TD><TD>BIC</TD><TD>BMCADR9</TD></TR><TR><TD height="19">IND</TD><TD>BIC</TD><TD><P>BMCADR10</P></TD></TR></TBODY></TABLE><P>In the Above data , i have to build a chart based on the Country code as Dimension and Count (List Type) as Expression</P><P></P><P>Condition : I should Consider the List Type with only DISTINCT MAR (Out of 10 MAR , only 8 are distinct)</P><P></P><P>Regards,</P><P>Senthil</P></BODY></HTML> Tue, 12 May 2015 09:15:54 GMT https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841475#M531938 2015-05-12T09:15:54Z Re: Distinct Records in Chart https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841476#M531939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>User AGGR()</P><P></P><P>Try like AGGR(Count(Distinct List Type),Country,Mar)</P><P></P><P>Regards</P></BODY></HTML> Tue, 12 May 2015 09:28:36 GMT https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841476#M531939 PrashantSangle 2015-05-12T09:28:36Z Re: Distinct Records in Chart https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841477#M531940 <HTML><HEAD></HEAD><BODY><P>Use this expr</P><P>=Count(DISTINCT MAR)</P></BODY></HTML> Tue, 12 May 2015 09:46:40 GMT https://community.qlik.com/t5/QlikView/Distinct-Records-in-Chart/m-p/841477#M531940 anbu1984 2015-05-12T09:46:40Z