Date Lookup

[manpri7078]

Hi All,

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.

I am not able to work out how to do that ?

Regards,

[swuehl · Accepted solution]

Try using the FirstSortedValue() function:

=FirstSortedValue(Date, LME)

for the Date of min LME (assuming a numeric LME value), and

=FirstSortedValue(Date, -LME)

for the Date of max LME.