Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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))))