topic Text lookup in QlikView https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492240#M549056 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I suppose it's to easy to find, but I'm lost...<BR />In my table I have fields "Max Temperature" (Tempmax) and Date (Xdate). <BR />What I'd like to achieve is to show the Date with the highest 'Tempmax'.</P><P>Something like "Highest temperature 34,1 was on 22-7-2013"</P><P></P><P>Anyone?</P><P>See attachment</P></BODY></HTML> Thu, 09 Jan 2014 21:01:00 GMT fred_s 2014-01-09T21:01:00Z Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492240#M549056 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I suppose it's to easy to find, but I'm lost...<BR />In my table I have fields "Max Temperature" (Tempmax) and Date (Xdate). <BR />What I'd like to achieve is to show the Date with the highest 'Tempmax'.</P><P>Something like "Highest temperature 34,1 was on 22-7-2013"</P><P></P><P>Anyone?</P><P>See attachment</P></BODY></HTML> Thu, 09 Jan 2014 21:01:00 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492240#M549056 fred_s 2014-01-09T21:01:00Z Re: Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492241#M549057 <HTML><HEAD></HEAD><BODY><P>Fred,</P><P>I think the function FirstSortedValue() is what you need.&nbsp; Get the Date value sorted by temperature (negative for descending):</P><P>FirstSortedValue(Xdate, -Tempmax)</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Thu, 09 Jan 2014 21:03:55 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492241#M549057 Anonymous 2014-01-09T21:03:55Z Re: Re: Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492242#M549059 <HTML><HEAD></HEAD><BODY><P>Another option (see the attached).</P></BODY></HTML> Thu, 09 Jan 2014 21:06:31 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492242#M549059 Nicole-Smith 2014-01-09T21:06:31Z Re: Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492243#M549062 <HTML><HEAD></HEAD><BODY><P>If I could, I'd love to give 10 points to both of you but it's not possible <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> </P><P>Thanks Michael and Nicole!</P></BODY></HTML> Thu, 09 Jan 2014 21:15:24 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492243#M549062 fred_s 2014-01-09T21:15:24Z Re: Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492244#M549064 <HTML><HEAD></HEAD><BODY><P>See attached</P></BODY></HTML> Thu, 09 Jan 2014 21:31:42 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492244#M549064 iktrayanov 2014-01-09T21:31:42Z Re: Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492245#M549066 <HTML><HEAD></HEAD><BODY><P>What happens if there are more dates with max temp?</P></BODY></HTML> Thu, 09 Jan 2014 21:33:13 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492245#M549066 iktrayanov 2014-01-09T21:33:13Z Re: Text lookup https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492246#M549067 <HTML><HEAD></HEAD><BODY><P>Both solutions fail if there are more than one date with temperature = max(Tempmax).</P></BODY></HTML> Thu, 09 Jan 2014 21:49:08 GMT https://community.qlik.com/t5/QlikView/Text-lookup/m-p/492246#M549067 iktrayanov 2014-01-09T21:49:08Z