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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
user467341
Creator II
Creator II

Sorting issue in filter pane

Hi,

I have this filter pane:

user467341_0-1688612635081.png

Is it possible to relocate the "> 60000" to the bottom? I tried to play with the sort options but none works.

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

I would normally add a sort order in Script and then order the filter by that field.

I.e.

Load * inline [

RangeOrder:

5001 - 10000, 1

10000 - 15000,2

>60000,3

];

Range, RangeOrder

Marcel_Garcia
Contributor III
Contributor III

Try sorting by expression or creating a master dimension like:
IF([Range]='5001-10000', dual('5001-1000', 1),
    IF([Range]='10001-15000', dual('10001-15000', 2),
        IF([Range]='>60000', dual('>60000', 3))))