Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

randyallcat
New Contributor

Trying to return value associated with max(Table.Date)

I have 2 fields, pace and date. I'm trying to return the pace value for the highest date for a KPI chart. I can get the date by max(Table.Date), but not sure how to refer to the pace value associated with it.

In SQL I know it would be something like select pace where date = max(date).

I'm sure it's something simple, but I'm just not getting it.  Thanks in advance!

1 Solution

Accepted Solutions
MVP
MVP

Re: Trying to return value associated with max(Table.Date)

Try FirstSortedValue() function

FirstSortedValue([Pace Value], -[Table.Date])

2 Replies
MVP
MVP

Re: Trying to return value associated with max(Table.Date)

Try FirstSortedValue() function

FirstSortedValue([Pace Value], -[Table.Date])

randyallcat
New Contributor

Re: Trying to return value associated with max(Table.Date)

Perfect!  Thank you Sunny!