Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

fred_s
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Text lookup

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

6 Replies
mov
Esteemed Contributor III

Re: Text lookup

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

Re: Re: Text lookup

Another option (see the attached).

fred_s
Contributor III

Re: Text lookup

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

Thanks Michael and Nicole!

iktrayanov
Contributor III

Re: Text lookup

See attached

iktrayanov
Contributor III

Re: Text lookup

What happens if there are more dates with max temp?

iktrayanov
Contributor III

Re: Text lookup

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

Community Browser