topic Re: FirstSortedValue - return the max value... in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029704#M347761 <HTML><HEAD></HEAD><BODY><P>='Max OrderDate:</P><P>FirstSortedValue(DISTINCT OrderDate,Sale): ' &amp; <SPAN style="font-family: terminal,monaco;"><STRONG style="color: #3366ff;">Date(Max({&lt;Sale={"$(=Max(Sale))"}&gt;}OrderDate))</STRONG></SPAN></P></BODY></HTML> Tue, 02 Feb 2016 11:08:49 GMT tresB 2016-02-02T11:08:49Z FirstSortedValue - return the max value... https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029702#M347759 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Hi all</SPAN></P><P></P><P>I am trying to use the FirstSortedValue function - which I think is the correct function to use in my case, but am not able to achieve the correct result. In the example below I am trying to return the latest OrderDate for the max sales date, but based on the max sale value.</P><P></P><P>As there are three order dates with the same max value of Sale (19.6) without using the 'DISTINCT' syntax the firstsortedvalue does not return a result. However as shown in the yellow box below I wish to return the date of 10/01/2016 (the most recent date that is associated with the max sale amount)&nbsp; and <STRONG>not</STRONG> the OrderDate of 05/01/2016.</P><P></P><P>Any ideas are most welcome!</P><P></P><P>Thanks!</P><P></P><P><IMG alt="FSV.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113277_FSV.png" style="width: 620px; height: 260px;" /> !</P></BODY></HTML> Tue, 02 Feb 2016 10:52:50 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029702#M347759 2016-02-02T10:52:50Z Re: FirstSortedValue - return the max value... https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029703#M347760 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>=FirstSortedValue(DISTINCT OrderDate,-(Sale*100000+OrderDate))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113278_Capture.PNG" style="height: 161px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Tue, 02 Feb 2016 11:08:22 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029703#M347760 sunny_talwar 2016-02-02T11:08:22Z Re: FirstSortedValue - return the max value... https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029704#M347761 <HTML><HEAD></HEAD><BODY><P>='Max OrderDate:</P><P>FirstSortedValue(DISTINCT OrderDate,Sale): ' &amp; <SPAN style="font-family: terminal,monaco;"><STRONG style="color: #3366ff;">Date(Max({&lt;Sale={"$(=Max(Sale))"}&gt;}OrderDate))</STRONG></SPAN></P></BODY></HTML> Tue, 02 Feb 2016 11:08:49 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-return-the-max-value/m-p/1029704#M347761 tresB 2016-02-02T11:08:49Z