Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

Date based on max row id

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

13 Replies
New-Qlik
Creator II
Creator II
Author

 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
Partner - Master
Partner - Master

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

Jordy

Climber

Work smarter, not harder
anushree1
Specialist II
Specialist II

Please try the below expression :

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

New-Qlik
Creator II
Creator II
Author

Thanks it worked.