Custom sorting a Listbox

[Evan0211]

I have a Listbox filter pane with strings.

'Standards 1'

'Standards 2'

'Standards 3'

'Below Standards'

I need to have the dropdown list in the order above. If I order it alphabetically, it shows as Below Standards, 1, 2, 3. If I sort it alphabetically descending it is 3, 2, 1, Below Standards.  How can I get it to sort 1, 2, 3, Below Standards?

[PhanThanhSon]

Hi,

You will need to use the dual function here. Here's a good example using Qlik to sort the days of the week, which can't be logically sorted numerically or alphabetically (considering they are just strings).

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunct....

best regards Son

[marksouzacosta]

Hi @Evan0211,

You have to associate a numeric value to the text values using Dual statement. This way you can customize the sort sequence in any way you need.

StandardList:
LOAD 
	Dual(StandardName,StandardValue) AS StandardName
INLINE [
StandardName, StandardValue
Standards 1, 1
Standards 2, 2
Standards 3, 3
Below Standards, 4
];

The Auto Sorting should work but if not, you can specify in your charts to sort it numerically:

[MatheusC]

@Evan0211 
Try this:

In sort by expression enter,
match(Field, ‘Below Standards’)

and keep it sorting as ascending.

- Matheus