Limiting to the most recent date/time

[QlikSenseUser2]

I'm trying to only show the most recent location based on the  Max(updated). It keeps showing both locations, but if I remove the locations and just the Max(updated) by itself it shows the correct Max(updated). I'm trying to only show the most recent location based on the  Max(updated). Just don't know-how ☹️

[Vegar · Accepted solution]

try using firstsortedvalue() instead of your location dimension. 

=firstsortedvalue([current_location], -[updated_at])

[QlikSenseUser2]

Thanks that worked!! 😀