topic Re: First Sorted Value in Auto Sorting in App Development

First Sorted Value in Auto Sorting

abonnery — Fri, 15 Nov 2024 23:21:27 GMT

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!

Re: First Sorted Value in Auto Sorting

Or — Mon, 03 Jan 2022 13:58:06 GMT

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

Re: First Sorted Value in Auto Sorting

abonnery — Mon, 03 Jan 2022 14:02:39 GMT

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

Re: First Sorted Value in Auto Sorting

Or — Mon, 03 Jan 2022 14:07:13 GMT

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

MaxString(All [Cost Baseline Version - FA])

Re: First Sorted Value in Auto Sorting

abonnery — Mon, 03 Jan 2022 14:19:10 GMT

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 ?)