topic Re: Need help for dublicate values in QlikView https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770479#M273533 <HTML><HEAD></HEAD><BODY><P>Sir,</P><P></P><P>I want only one record when I select serial number and I used Count(Distinct [Order No]) this..</P><P></P><P>but not yet come..</P></BODY></HTML> Mon, 12 Jan 2015 09:47:15 GMT prma7799 2015-01-12T09:47:15Z Need help for dublicate values https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770477#M273531 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have 1 serial number and one 1 order number and we have multiple dealer for wholesale.</P><P></P><P>My query is when I select 1 serial number I will get two record for dealer and when select order number then will get one dealer record</P><P></P><P>so I need only one record when I select serial number.</P><P></P><P>Thanks</P><P>Prashant</P></BODY></HTML> Mon, 12 Jan 2015 09:28:49 GMT https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770477#M273531 prma7799 2015-01-12T09:28:49Z Re: Need help for dublicate values https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770478#M273532 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use Distinct to get Single records</P><P></P><P>Ex:- Count(Distinct [Order No])</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 12 Jan 2015 09:33:24 GMT https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770478#M273532 its_anandrjs 2015-01-12T09:33:24Z Re: Need help for dublicate values https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770479#M273533 <HTML><HEAD></HEAD><BODY><P>Sir,</P><P></P><P>I want only one record when I select serial number and I used Count(Distinct [Order No]) this..</P><P></P><P>but not yet come..</P></BODY></HTML> Mon, 12 Jan 2015 09:47:15 GMT https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770479#M273533 prma7799 2015-01-12T09:47:15Z Re: Need help for dublicate values https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770480#M273534 <HTML><HEAD></HEAD><BODY><P>can you share an example with data</P></BODY></HTML> Mon, 12 Jan 2015 09:53:11 GMT https://community.qlik.com/t5/QlikView/Need-help-for-dublicate-values/m-p/770480#M273534 Yousef_Amarneh 2015-01-12T09:53:11Z