topic Re: Date Lookup in QlikView https://community.qlik.com/t5/QlikView/Date-Lookup/m-p/477047#M1129362 <HTML><HEAD></HEAD><BODY><P>Try using the FirstSortedValue() function:</P><P></P><P>=FirstSortedValue(Date, LME)</P><P></P><P>for the Date of min LME (assuming a numeric LME value), and</P><P></P><P>=FirstSortedValue(Date, -LME)</P><P></P><P>for the Date of max LME.</P></BODY></HTML> Thu, 12 Dec 2013 11:38:19 GMT swuehl 2013-12-12T11:38:19Z Date Lookup https://community.qlik.com/t5/QlikView/Date-Lookup/m-p/477046#M1129361 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a QV Document, showing Date Wise LME Data. I have created a TextBox object showing the Minimum or Maximum LME for a given Date range by using min() and max() function. Now I want to show in another TextBox object on which Date that miniumum LME was or maximum LME was.</P><P></P><P>I am not able to work out how to do that ?</P><P></P><P>Regards,</P></BODY></HTML> Thu, 12 Dec 2013 11:16:34 GMT https://community.qlik.com/t5/QlikView/Date-Lookup/m-p/477046#M1129361 manpri7078 2013-12-12T11:16:34Z Re: Date Lookup https://community.qlik.com/t5/QlikView/Date-Lookup/m-p/477047#M1129362 <HTML><HEAD></HEAD><BODY><P>Try using the FirstSortedValue() function:</P><P></P><P>=FirstSortedValue(Date, LME)</P><P></P><P>for the Date of min LME (assuming a numeric LME value), and</P><P></P><P>=FirstSortedValue(Date, -LME)</P><P></P><P>for the Date of max LME.</P></BODY></HTML> Thu, 12 Dec 2013 11:38:19 GMT https://community.qlik.com/t5/QlikView/Date-Lookup/m-p/477047#M1129362 swuehl 2013-12-12T11:38:19Z