Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSenseUser2
Contributor III
Contributor III

Limiting to the most recent timestamp

I'm trying only to show the most recent timestamp.

 

QlikSenseUser2_0-1636505793097.pngQlikSenseUser2_1-1636505841156.png

QlikSenseUser2_2-1636505866923.png

 

 

1 Solution

Accepted Solutions
QlikSenseUser2
Contributor III
Contributor III
Author

This  worked

firstsortedvalue([current_location], -[updated_at])  

View solution in original post

3 Replies
Lisa_P
Employee
Employee

As you are using the location as a dimension, you are getting the Last time updated per trailer and location combination.

If you just asked for the Last time updated per trailer and then matched that for the location you may get what you want.

Dimension: Trailer #

Measures: Last Time updated = Max(updated_at)
                      Most recent location = only({<updated_at={'$(=Max(updated_at)'}>}current_location)

 

QlikSenseUser2
Contributor III
Contributor III
Author

When I try that it shows a null value 

QlikSenseUser2_0-1636552197766.png

 

QlikSenseUser2
Contributor III
Contributor III
Author

This  worked

firstsortedvalue([current_location], -[updated_at])