Discussion Board for collaboration on QlikView Layout & Visualizations.
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"
Go to Solution.
I think the function FirstSortedValue() is what you need. Get the Date value sorted by temperature (negative for descending):
Another option (see the attached).
If I could, I'd love to give 10 points to both of you but it's not possible :-(
Thanks Michael and Nicole!
What happens if there are more dates with max temp?
Both solutions fail if there are more than one date with temperature = max(Tempmax).