Limiting to the most recent timestamp

[QlikSenseUser2]

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

[Lisa_P]

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]

When I try that it shows a null value 

[QlikSenseUser2 · Accepted solution]

This  worked

firstsortedvalue([current_location], -[updated_at])