Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Get value of the field for max value of other field

Hi community,

Let's say there is raw data with following columns:

Date, Metric ID, Metric Value

I need to create a result table with following columns:

Metric ID, Metric Value

In Metric Value column I need to show a value from max day each metric appeared.

What expression I need to use?

Thank you in advance

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

=FirstSortedValue([Metric Value],-Date)

View solution in original post

1 Reply
Highlighted
MVP
MVP

=FirstSortedValue([Metric Value],-Date)

View solution in original post