First Sorted Value in Auto Sorting

[abonnery]

Dear Qlik Sense experts, 

I was wondering how to get the max of this list from the auto sorting of Qlik Sense. To be more precise, from this very simple list, I would like to obtain the value 'RF_2022_02'

I tried using the max (not working at all) or the function FirstSortedValue but it didn't work as I intended (see enclosed capture). 

There isn't other fields that can help the field as a max appart from the auto sorting.

Do you know how I can get this value ?

Thank you for your help!

[Or]

Try MaxString({1} [Cost Baseline Version - FA]) rather than Max(), as the latter is intended for numeric values.

[abonnery]

It's not showing 'RF_2022_02', as I would like  instead it shows all the values in the "right order"

[Or]

Sorry, moment of distraction there. {1} only ignores selections, not dimensions.

MaxString(All [Cost Baseline Version - FA])

[abonnery · Accepted solution]

Perfect, it worked like a charm !  Thank you very much.

Can you explain why the maxstring worked and not the max ? And why did you add 'All' before ? (is it different to total ?)