Date based on max row id

[New-Qlik]

hi

I have to pick date where row_id is maximum .

Date                                             Row_id   Message

1/11/2019 12:00:00             1                   Data Error

1/11/2019 12:10:00           2                   Data Refreshed 

I want to display second row . I tried max as script function but didn't work

Thanks

Avneet

[New-Qlik]

 Variable overview its says 2 for max_row_id wich is correct and it shows correct for date as well.

But for message it is not. Do KPI shows Text data .

[JordyWegman]

That is good, try to put single quotes around the variable ='$(max_row_id )'

Jordy

Climber

[anushree1 · Accepted solution]

Please try the below expression :

=only({<Row_id={$(=max(Row_id))}>}Date)

[New-Qlik]

Thanks it worked.