https://community.qlik.com/t5/App-Development/Date-wise-Min-and-Max-and-Second-Min-Date-value/m-p/2528108#M107484 <P>Something like:</P><DIV><FONT face="courier new,courier">Data:</FONT></DIV><DIV><FONT face="courier new,courier">Load TimeStamp(TimeStamp#(TS, 'MM/DD/YYYYY hh:mm')) as TS Inline [</FONT></DIV><DIV><FONT face="courier new,courier">TS</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:10</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:11</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:12</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:15</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 7:11</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 7:26</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 11:11</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 11:50</FONT></DIV><DIV><FONT face="courier new,courier">];</FONT></DIV><DIV>&nbsp;</DIV><DIV><FONT face="courier new,courier">MinMax:</FONT></DIV><DIV><FONT face="courier new,courier">Load</FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TheDate,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TimeStamp(Min(TS)) as MinTS,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TimeStamp(Min(TS, 2)) as MinTS2nd,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TimeStamp(Max(TS)) as MaxTS</SPAN></FONT></DIV><DIV><FONT face="courier new,courier">Group By TheDate;</FONT></DIV><DIV><FONT face="courier new,courier">LOAD&nbsp;</FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TS,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; Date(Floor(TS)) as TheDate</SPAN></FONT></DIV><DIV><FONT face="courier new,courier">Resident Data;</FONT></DIV><DIV>&nbsp;</DIV><DIV>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></DIV> Thu, 21 Aug 2025 23:24:21 GMT rwunderlich 2025-08-21T23:24:21Z https://community.qlik.com/t5/App-Development/Date-wise-Min-and-Max-and-Second-Min-Date-value/m-p/2528091#M107483 <DIV class=""><DIV class=""><DIV class=""><DIV class="">Date wise Min date, max Date, Second Min date</DIV></DIV></DIV></DIV><DIV class="">&nbsp;</DIV><DIV class=""><DIV class=""><P>Hi Team,</P><P>I have a date field like MM/DD/YYYY HH:MM</P><P>Date</P><P>04/2/2025 5:10</P><P>04/2/2025 5:11</P><P>04/2/2025 5:12</P><P>04/2/2025 5:15</P><P>05/2/2025 7:11</P><P>05/2/2025 7:26</P><P>05/2/2025 11:11</P><P>05/2/2025 11:50</P><P>&nbsp;</P><P>Output:</P><P>--------------------------</P><P>&nbsp;Min Date:</P><P>04/2/2025 5:10</P><P>05/2/2025 7:11</P><P>&nbsp;Second Min date:</P><P>04/2/2025 5:11</P><P>05/2/2025 7:26</P><P>Max date:</P><P>04/2/2025 5:15</P><P>05/2/2025 11:50</P><P>&nbsp;Thanks, advance.</P><P>Ram</P></DIV></DIV> Thu, 21 Aug 2025 17:44:13 GMT https://community.qlik.com/t5/App-Development/Date-wise-Min-and-Max-and-Second-Min-Date-value/m-p/2528091#M107483 lakshman1031 2025-08-21T17:44:13Z https://community.qlik.com/t5/App-Development/Date-wise-Min-and-Max-and-Second-Min-Date-value/m-p/2528108#M107484 <P>Something like:</P><DIV><FONT face="courier new,courier">Data:</FONT></DIV><DIV><FONT face="courier new,courier">Load TimeStamp(TimeStamp#(TS, 'MM/DD/YYYYY hh:mm')) as TS Inline [</FONT></DIV><DIV><FONT face="courier new,courier">TS</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:10</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:11</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:12</FONT></DIV><DIV><FONT face="courier new,courier">04/2/2025 5:15</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 7:11</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 7:26</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 11:11</FONT></DIV><DIV><FONT face="courier new,courier">05/2/2025 11:50</FONT></DIV><DIV><FONT face="courier new,courier">];</FONT></DIV><DIV>&nbsp;</DIV><DIV><FONT face="courier new,courier">MinMax:</FONT></DIV><DIV><FONT face="courier new,courier">Load</FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TheDate,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TimeStamp(Min(TS)) as MinTS,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TimeStamp(Min(TS, 2)) as MinTS2nd,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TimeStamp(Max(TS)) as MaxTS</SPAN></FONT></DIV><DIV><FONT face="courier new,courier">Group By TheDate;</FONT></DIV><DIV><FONT face="courier new,courier">LOAD&nbsp;</FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; TS,</SPAN></FONT></DIV><DIV><FONT face="courier new,courier"><SPAN>&nbsp; Date(Floor(TS)) as TheDate</SPAN></FONT></DIV><DIV><FONT face="courier new,courier">Resident Data;</FONT></DIV><DIV>&nbsp;</DIV><DIV>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></DIV> Thu, 21 Aug 2025 23:24:21 GMT https://community.qlik.com/t5/App-Development/Date-wise-Min-and-Max-and-Second-Min-Date-value/m-p/2528108#M107484 rwunderlich 2025-08-21T23:24:21Z