topic Show the max datetime value data. in Water Cooler https://community.qlik.com/t5/Water-Cooler/Show-the-max-datetime-value-data/m-p/361677#M1080 <HTML><HEAD></HEAD><BODY><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="339"><TBODY><TR><TD class="xl25" height="17" width="64">Sr.No </TD><TD class="xl25" width="64">Mode</TD><TD class="xl25" width="74">Department</TD><TD class="xl24" width="137">Date</TD></TR><TR><TD class="xl25" height="17">101</TD><TD class="xl25">Rel</TD><TD class="xl25">A</TD><TD class="xl24">3/15/2012 7:21:03 PM</TD></TR><TR><TD class="xl25" height="17">101</TD><TD class="xl25">Rel</TD><TD class="xl25">B</TD><TD class="xl24">3/15/2012 7:20:32 PM</TD></TR><TR><TD class="xl25" height="17">101</TD><TD class="xl25">Cust</TD><TD class="xl25">C</TD><TD class="xl24">3/15/2012 7:21:24 PM</TD></TR></TBODY></TABLE><P></P><P></P><P>Need the output only on the base of date column, which the the max date.</P><P></P><P>i.e&nbsp; - </P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 339px;"><TBODY><TR><TD class="xl25" height="17" style="height: 12.75pt; width: 48pt;" width="64">101</TD><TD class="xl25" style="width: 48pt;" width="64">Cust</TD><TD class="xl25" style="width: 56pt;" width="74">C</TD><TD class="xl24" style="width: 103pt;" width="137">3/15/2012 7:21:24 PM</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks &amp; Regards</P><P>Akumar</P></BODY></HTML> Wed, 21 Mar 2012 09:16:14 GMT sona_sa 2012-03-21T09:16:14Z Show the max datetime value data. https://community.qlik.com/t5/Water-Cooler/Show-the-max-datetime-value-data/m-p/361677#M1080 <HTML><HEAD></HEAD><BODY><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="339"><TBODY><TR><TD class="xl25" height="17" width="64">Sr.No </TD><TD class="xl25" width="64">Mode</TD><TD class="xl25" width="74">Department</TD><TD class="xl24" width="137">Date</TD></TR><TR><TD class="xl25" height="17">101</TD><TD class="xl25">Rel</TD><TD class="xl25">A</TD><TD class="xl24">3/15/2012 7:21:03 PM</TD></TR><TR><TD class="xl25" height="17">101</TD><TD class="xl25">Rel</TD><TD class="xl25">B</TD><TD class="xl24">3/15/2012 7:20:32 PM</TD></TR><TR><TD class="xl25" height="17">101</TD><TD class="xl25">Cust</TD><TD class="xl25">C</TD><TD class="xl24">3/15/2012 7:21:24 PM</TD></TR></TBODY></TABLE><P></P><P></P><P>Need the output only on the base of date column, which the the max date.</P><P></P><P>i.e&nbsp; - </P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 339px;"><TBODY><TR><TD class="xl25" height="17" style="height: 12.75pt; width: 48pt;" width="64">101</TD><TD class="xl25" style="width: 48pt;" width="64">Cust</TD><TD class="xl25" style="width: 56pt;" width="74">C</TD><TD class="xl24" style="width: 103pt;" width="137">3/15/2012 7:21:24 PM</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks &amp; Regards</P><P>Akumar</P></BODY></HTML> Wed, 21 Mar 2012 09:16:14 GMT https://community.qlik.com/t5/Water-Cooler/Show-the-max-datetime-value-data/m-p/361677#M1080 sona_sa 2012-03-21T09:16:14Z Show the max datetime value data. https://community.qlik.com/t5/Water-Cooler/Show-the-max-datetime-value-data/m-p/361678#M1081 <HTML><HEAD></HEAD><BODY><P>Use setexpression <EM>sum({&lt;[<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Date</SPAN>]={'$(=Max([<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Date</SPAN>]))'}&gt;}Value)</EM></P></BODY></HTML> Wed, 21 Mar 2012 11:10:18 GMT https://community.qlik.com/t5/Water-Cooler/Show-the-max-datetime-value-data/m-p/361678#M1081 2012-03-21T11:10:18Z