Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
MVP
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.