topic Re: Sort the values in App Development

Sort the values

ali_hijazi — Mon, 04 May 2026 07:18:09 GMT

Hello
got the dimension as seen below
these values got related numeric values in another dimension
is there a way to sort the values by the numeric dimension when the user selects the values from the upper filter bar?

Re: Sort the values

priscilarubim — Mon, 04 May 2026 15:27:04 GMT

If your numeric dimension is called "MovementSortOrder" for exemple, you can solve this in the Filter pane / Listbox properties in Qlik Sense / Qlik Cloud:

Select the filter object (Movement)
In the properties panel on the right, go to Sorting
Turn off Auto sorting
Uncheck "Sort by alphabetical"
Check "Sort by expression" and use an expression like:

=MovementSortOrder

Re: Sort the values

alexquimu — Mon, 04 May 2026 16:59:57 GMT

Hey @ali_hijazi,

If you need the selections sorted specifically within the Filter Pane object, @priscilarubim's approach is the way to go.

However, if you are trying to control the sort order in the Top Selection Bar, it’s a different story. Currently, you can't achieve a custom sort there unless you create a Dual() field in the load script (see my previous post here: Solved: How to sort the selection filter at the top of a s... - Qlik Community - 2517844). If you require the sort order to react to a measure, this won't work since this method is static with the original definitions.

A few things I’ve tested but not working:

Creating a synthetic dimension with Aggr() Function: Creating a synthetic dimension (master dimension) like Aggr(Dual(field, -sum(amount)), field) sorts correctly within a chart/filter pane, but the Selection Bar still reverts to the original field's default sorting (alphabetically).
CalcDim() function: previous approach wrapped in a CalcDim() function (CalcDim - chart function | Qlik Sense on Windows Help), but it's still not working as selections are done in the original fields.

The Dual() method remains the only consistent fix, though as you noted, it can't be assigned to a measure in the UI.

Maybe someone here can help or clarify if I've missed something.

Regards,

Re: Sort the values

Vegar — Tue, 05 May 2026 05:04:38 GMT

If the numeric value is important for the Movement dimension then you could consider loading the dimension as a dual value using the Movement as your string representation and your "Movement Sort Order" field as the underlying numeric value.

In the script do this when loading the data:

Dual(Movement, [Movement Sort Order]) as Movement

By saving it as a dual then you will have the option to sort that dimension numeric.