Create a variable
vlastReload=max([Reload date]) in control+alt+v
in expression you can write below
see the attached file
hope this helps
Current state example.qvw 139.2 K
Thank you for the answer - it works, but I was not specific enough.
There can be a situation where the container is no longer in the list, but I still want to see the value from when it was uploaded last time.
I have added a container D to my example, where the last update was on the 28th. I still need to see it on my list with status 2.
Thanks for your interest.
Current state example_1.qvw 137.5 K
Jakob - Instead of following Set Analysis approach you can solve this by using FirstSortedValue function. Here is what you need...
FirstSortedValue( Status, -[Reload date])
I have used the minus sign before [Reload date] to sort in desc order or last sorted value instead of first sorted value.
I understand itss hard - not to think of Set Analysis but sometimes we need to step back to get things working.
I hope this helps!