Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fred_s
Partner - Creator III
Partner - Creator III

Text lookup

Hi,

I suppose it's to easy to find, but I'm lost...
In my table I have fields "Max Temperature" (Tempmax) and Date (Xdate).
What I'd like to achieve is to show the Date with the highest 'Tempmax'.

Something like "Highest temperature 34,1 was on 22-7-2013"

Anyone?

See attachment

1 Solution

Accepted Solutions
Anonymous
Not applicable

Fred,

I think the function FirstSortedValue() is what you need.  Get the Date value sorted by temperature (negative for descending):

FirstSortedValue(Xdate, -Tempmax)

Regards,

Michael

View solution in original post

6 Replies
Anonymous
Not applicable

Fred,

I think the function FirstSortedValue() is what you need.  Get the Date value sorted by temperature (negative for descending):

FirstSortedValue(Xdate, -Tempmax)

Regards,

Michael

Nicole-Smith

Another option (see the attached).

fred_s
Partner - Creator III
Partner - Creator III
Author

If I could, I'd love to give 10 points to both of you but it's not possible 😞

Thanks Michael and Nicole!

iktrayanov
Creator III
Creator III

See attached

iktrayanov
Creator III
Creator III

What happens if there are more dates with max temp?

iktrayanov
Creator III
Creator III

Both solutions fail if there are more than one date with temperature = max(Tempmax).