topic Re: Pick the most recent date in QlikView https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956275#M645114 <HTML><HEAD></HEAD><BODY><P>Another way is to use</P><P></P><P>=Max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date</SPAN>)</P><P></P><P>This function can be used in the script or on tables as well so quite nifty.</P></BODY></HTML> Mon, 09 Nov 2015 10:33:32 GMT Anonymous 2015-11-09T10:33:32Z Pick the most recent date https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956273#M645111 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>One of my tables has dates and comments for SKU's in my catalogue. I just want to see the most recent comment in my Straight Table. </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SKU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Comment</P><P>-----------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------------&nbsp;&nbsp;&nbsp; ----------------------</P><P>05/11/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Will be available in 23/Nov&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --------------&gt; most recent comment that I want to see</P><P>04/11/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Awaiting response</P><P></P><P>Can anyone help with a solution?</P><P></P><P>Thanks</P><P>MT</P></BODY></HTML> Fri, 06 Nov 2015 18:44:42 GMT https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956273#M645111 london1980 2015-11-06T18:44:42Z Re: Pick the most recent date https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956274#M645113 <HTML><HEAD></HEAD><BODY><P>Try </P><P></P><P>=FirstSortedValue( Comment, -Date)</P><P></P><P>assuming Date has a numeric representation, like a Date created by QV date functions.</P></BODY></HTML> Fri, 06 Nov 2015 20:17:18 GMT https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956274#M645113 swuehl 2015-11-06T20:17:18Z Re: Pick the most recent date https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956275#M645114 <HTML><HEAD></HEAD><BODY><P>Another way is to use</P><P></P><P>=Max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date</SPAN>)</P><P></P><P>This function can be used in the script or on tables as well so quite nifty.</P></BODY></HTML> Mon, 09 Nov 2015 10:33:32 GMT https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956275#M645114 Anonymous 2015-11-09T10:33:32Z Re: Pick the most recent date https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956276#M645115 <HTML><HEAD></HEAD><BODY><P>You can try:</P><P></P><P>LastValue(Comment)</P><P></P><P>group by Date</P></BODY></HTML> Mon, 09 Nov 2015 10:42:47 GMT https://community.qlik.com/t5/QlikView/Pick-the-most-recent-date/m-p/956276#M645115 Anonymous 2015-11-09T10:42:47Z