Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
SAMSAM
Partner - Contributor
Partner - Contributor

Sorting Values in a Filter Pane

I wish sort values in a filter pane first alphabetically, then by the string length.
How can I go about this?
I can sort alphabetically by checking the "Sort Alphabetical" check box in Sort pane/section.
I can sort string length by checking the use expression checkbox, then with the function: Len(myString). 

But how to combine them both?
In sql, this is "order by..., then by..."

Labels (2)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post some sample data and your expected output?

-Rob

SAMSAM
Partner - Contributor
Partner - Contributor
Author

del.png

The above is a sample of what I would like to achieve.
To improve on my OP and to be more concise,
what I want is to sort the first word alphabetically then sort by string length.
In this manner, the first word/code of the values will be grouped together, 
then sorted arranged by the string length.
Layout in this manner looks neater.