topic Re: Get Max Date/Time by ID in QlikView https://community.qlik.com/t5/QlikView/Get-Max-Date-Time-by-ID/m-p/47436#M784862 <HTML><HEAD></HEAD><BODY><P>Hi Karan, PFA. I get the max for ID 4 is P8</P></BODY></HTML> Sun, 04 Mar 2018 19:04:22 GMT rubenmarin 2018-03-04T19:04:22Z Get Max Date/Time by ID https://community.qlik.com/t5/QlikView/Get-Max-Date-Time-by-ID/m-p/47435#M784861 <HTML><HEAD></HEAD><BODY><P>Need to identify the max Date of each ID,the challenge for me is Sales Date would be same Date for same ID's, ideally Maxdate shoukd be the maxdate and time. I have attached source file for your reference.</P><P></P><P>Example (MaxDate/Time):<BR />2/4/18 1:45 and 2/4/18 13:15<BR /><STRONG>MaxDate: </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>2/4/18 13:15</STRONG></SPAN></P><P></P><P></P><P></P><P><IMG alt="Maxdate.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195249_Maxdate.PNG" style="height: 304px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-Max-Date-Time-by-ID/m-p/47435#M784861 karan_kn 2020-11-25T16:16:04Z Re: Get Max Date/Time by ID https://community.qlik.com/t5/QlikView/Get-Max-Date-Time-by-ID/m-p/47436#M784862 <HTML><HEAD></HEAD><BODY><P>Hi Karan, PFA. I get the max for ID 4 is P8</P></BODY></HTML> Sun, 04 Mar 2018 19:04:22 GMT https://community.qlik.com/t5/QlikView/Get-Max-Date-Time-by-ID/m-p/47436#M784862 rubenmarin 2018-03-04T19:04:22Z