topic Re: Show the latest date only for duplicate data in QlikView https://community.qlik.com/t5/QlikView/Show-the-latest-date-only-for-duplicate-data/m-p/823806#M1036140 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try like this</P><P></P><P>LOAD</P><P>number,</P><P>id,</P><P>Date(Max(date)) AS date</P><P>FROM DataSource</P><P>GROUP BY number, id;</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 21 Jan 2015 05:47:12 GMT jagan 2015-01-21T05:47:12Z Show the latest date only for duplicate data https://community.qlik.com/t5/QlikView/Show-the-latest-date-only-for-duplicate-data/m-p/823805#M1036139 <HTML><HEAD></HEAD><BODY><P>data given</P><P></P><P></P><P></P><P></P><P>number&nbsp;&nbsp; id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/1/2015</P><P>124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/12/2014</P><P>125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (blank) </P><P>125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5/1/2015</P><P>125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8/1/2015</P><P>126&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7/7/2015</P><P>126&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (blank)</P><P></P><P></P><P></P><P></P><P>expected result:</P><P></P><P></P><P>number&nbsp;&nbsp; id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/1/2015</P><P>124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/12/2014</P><P>125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8/1/2015</P><P>126&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7/7/2015</P><P></P><P></P><P></P><P></P><P>Please help. Thanks.</P></BODY></HTML> Wed, 21 Jan 2015 02:57:06 GMT https://community.qlik.com/t5/QlikView/Show-the-latest-date-only-for-duplicate-data/m-p/823805#M1036139 Anonymous 2015-01-21T02:57:06Z Re: Show the latest date only for duplicate data https://community.qlik.com/t5/QlikView/Show-the-latest-date-only-for-duplicate-data/m-p/823806#M1036140 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try like this</P><P></P><P>LOAD</P><P>number,</P><P>id,</P><P>Date(Max(date)) AS date</P><P>FROM DataSource</P><P>GROUP BY number, id;</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 21 Jan 2015 05:47:12 GMT https://community.qlik.com/t5/QlikView/Show-the-latest-date-only-for-duplicate-data/m-p/823806#M1036140 jagan 2015-01-21T05:47:12Z