topic Re: Removing duplicate entries in QlikView https://community.qlik.com/t5/QlikView/Removing-duplicate-entries/m-p/300801#M708037 <HTML><HEAD></HEAD><BODY><P>Hi Becky,</P><P></P><P>Check out the attachment and let me know if it is not the desired result.</P><P></P><P>In you script using group function (max) without group by clause might be the problem. Group by sequence would automatically result in distinct results.</P><P></P><P>Hope this answers your question.</P><P></P><P>Kiran.</P></BODY></HTML> Mon, 07 Nov 2011 18:25:01 GMT 2011-11-07T18:25:01Z Removing duplicate entries https://community.qlik.com/t5/QlikView/Removing-duplicate-entries/m-p/300800#M708036 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I have a multiple file data feed that I am trying to combine whilst removing duplicates, but am having trouble selecting only the latest entries. </P><P></P><P>To make this simple, I have create two data files (1.xls and 2.xls) and want to combine these to one table using the sequence and maximum date to show what the description is - why does this create multiple lines in the qvw attached?</P><P></P><P>Any help will be very gratefully received. </P><P></P><P>Kind Regards</P><P></P><P>Becky</P></BODY></HTML> Mon, 07 Nov 2011 16:07:12 GMT https://community.qlik.com/t5/QlikView/Removing-duplicate-entries/m-p/300800#M708036 2011-11-07T16:07:12Z Re: Removing duplicate entries https://community.qlik.com/t5/QlikView/Removing-duplicate-entries/m-p/300801#M708037 <HTML><HEAD></HEAD><BODY><P>Hi Becky,</P><P></P><P>Check out the attachment and let me know if it is not the desired result.</P><P></P><P>In you script using group function (max) without group by clause might be the problem. Group by sequence would automatically result in distinct results.</P><P></P><P>Hope this answers your question.</P><P></P><P>Kiran.</P></BODY></HTML> Mon, 07 Nov 2011 18:25:01 GMT https://community.qlik.com/t5/QlikView/Removing-duplicate-entries/m-p/300801#M708037 2011-11-07T18:25:01Z