topic Sorting of GetFieldSelections() in App Development

Sorting of GetFieldSelections()

charlie03 — Wed, 12 Apr 2023 08:54:23 GMT

Hi,

I would like to understand how does Qlik Sense sort when displaying the values after applying the GetFieldSelections() function.

For example, I have the following loaded:

table: load * inline [ Selection Account Age Age Available Access Technology Channel Contract Binding Current Access Technology Flow Revenue Category ];

The loaded table is sorted alphabetically. When I use the GetFieldSelections(Selection, ', ' , 200) in the front end, I don't understand how it is sorted when displaying the figures.

If I select "Account Age" and "Age", I get the following result, which is alphabetically sorted:

Account Age, Age

However, if I add "Channel", I get the following result:

Channel, Account Age, Age

I would need that it is still sorted when clicking on the values.

Thanks for any help, it's highly appreciated!

Re: Sorting of GetFieldSelections()

marcus_sommer — Wed, 12 Apr 2023 11:30:53 GMT

Never really looked how the sorting happens within getfieldselections() and I rather doubt that there are possibilities to adjust the behaviour.

If you really need a string-list of the values you could use: concat(distinct FIELD, ',') to get the values alpha-numerical sorted. Concat() has further the option to add a numerical third parameter which defined the sort-order. Such parameter might be created within the load, for example per recno() or rowno().

If not such list is needed else the result should be used within a set analysis you may better take p() for it.

Re: Sorting of GetFieldSelections()

charlie03 — Wed, 12 Apr 2023 12:45:00 GMT

That worked, thanks!