topic How to eliminates the dupicates in stright table in QlikView https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463839#M565981 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P>&nbsp;&nbsp; i have which is like a&nbsp; Date field&nbsp; it showing&nbsp; n Number of dupicates&nbsp; and&nbsp;&nbsp;&nbsp; in script level&nbsp; i used&nbsp; load Distincrt&nbsp; also. XYZ&nbsp; </P><P></P><P></P><P>XYZ</P><P>09-09-2010</P><P>09-09-2010</P><P>09-09-2010</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Regards</P><P>surik147</P></BODY></HTML> Mon, 24 Dec 2012 12:04:38 GMT 2012-12-24T12:04:38Z How to eliminates the dupicates in stright table https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463839#M565981 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P>&nbsp;&nbsp; i have which is like a&nbsp; Date field&nbsp; it showing&nbsp; n Number of dupicates&nbsp; and&nbsp;&nbsp;&nbsp; in script level&nbsp; i used&nbsp; load Distincrt&nbsp; also. XYZ&nbsp; </P><P></P><P></P><P>XYZ</P><P>09-09-2010</P><P>09-09-2010</P><P>09-09-2010</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Regards</P><P>surik147</P></BODY></HTML> Mon, 24 Dec 2012 12:04:38 GMT https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463839#M565981 2012-12-24T12:04:38Z Re: How to eliminates the dupicates in stright table https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463840#M565982 <HTML><HEAD></HEAD><BODY><P>hi</P><P>use count(distinct(xyz))</P><P>thanks</P></BODY></HTML> Mon, 24 Dec 2012 12:15:29 GMT https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463840#M565982 2012-12-24T12:15:29Z Re: How to eliminates the dupicates in stright table https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463841#M565983 <HTML><HEAD></HEAD><BODY><P>sorry boss it not working </P></BODY></HTML> Mon, 24 Dec 2012 12:30:22 GMT https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463841#M565983 2012-12-24T12:30:22Z Re: How to eliminates the dupicates in stright table https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463842#M565984 <HTML><HEAD></HEAD><BODY><P>Make sure you're dates don't have time fractions or they will be distinct even though the date parts are the same. You can use the floor function to cut of the time fractions:</P><P></P><P>load distinct </P><P>floor(XYZ) as XYZ</P><P>from ....</P></BODY></HTML> Mon, 24 Dec 2012 12:44:02 GMT https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463842#M565984 Gysbert_Wassenaar 2012-12-24T12:44:02Z Re: How to eliminates the dupicates in stright table https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463843#M565985 <HTML><HEAD></HEAD><BODY><P>Thank for&nbsp;&nbsp; uer reply </P><P>it&nbsp; not working man </P></BODY></HTML> Mon, 24 Dec 2012 12:52:11 GMT https://community.qlik.com/t5/QlikView/How-to-eliminates-the-dupicates-in-stright-table/m-p/463843#M565985 2012-12-24T12:52:11Z