topic Re: max updated_date in QlikView https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787298#M1045180 <HTML><HEAD></HEAD><BODY><P>Use FirstSortedValue(Comment, -UpdatedDate)</P></BODY></HTML> Thu, 20 Nov 2014 11:45:41 GMT CELAMBARASAN 2014-11-20T11:45:41Z max updated_date https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787297#M1045179 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I need to show the latest comment in text box . </P><P>Ex . </P><P></P><P>I have </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 311px;"><TBODY><TR><TD class="xl63" height="17" width="67">Code</TD><TD class="xl63" style="border-left: none;" width="73">Comment</TD><TD class="xl63" style="border-left: none;" width="171">UpdatedDate</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1011</TD><TD class="xl64" style="border-top: none; border-left: none;">Test1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11/20/2014 16:18</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1011</TD><TD class="xl65" style="border-top: none; border-left: none;">Test2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11/20/2014 16:19</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;"><STRONG>1011</STRONG></TD><TD class="xl67" style="border-top: none; border-left: none;"><STRONG>Test3</STRONG></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;"><STRONG>11/20/2014 16:22</STRONG></TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1011</TD><TD class="xl65" style="border-top: none; border-left: none;">Test4</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11/20/2014 16:18</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1011</TD><TD class="xl64" style="border-top: none; border-left: none;">Test5</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11/20/2014 16:18</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1011</TD><TD class="xl65" style="border-top: none; border-left: none;">Test6</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11/20/2014 16:14</TD></TR></TBODY></TABLE><P></P><P>my test box should show Test3 as this comment is latest one. </P><P>Please suggest the expression.</P></BODY></HTML> Thu, 20 Nov 2014 11:43:18 GMT https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787297#M1045179 Anonymous 2014-11-20T11:43:18Z Re: max updated_date https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787298#M1045180 <HTML><HEAD></HEAD><BODY><P>Use FirstSortedValue(Comment, -UpdatedDate)</P></BODY></HTML> Thu, 20 Nov 2014 11:45:41 GMT https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787298#M1045180 CELAMBARASAN 2014-11-20T11:45:41Z Re: max updated_date https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787299#M1045181 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Mon, 23 Feb 2015 16:20:14 GMT https://community.qlik.com/t5/QlikView/max-updated-date/m-p/787299#M1045181 Anonymous 2015-02-23T16:20:14Z