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: 
Not applicable

how can I keep the order in my list box

hi dear experts

I have this list box

PH.PNG

and I want keep this sort,

but when I select the filter change it order to this

PHS.PNG

somebody know how can keep the first sort?

best regards\Roldan

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I believe the issue is your sort expression "=orw". When you make selections, some of the orw values are no longer included. They compute to null which sorts them to the top of the list.

The solution is to use a set as your sort expression that ignores selections.

=sum({1}orw)

-Rob

http://masterssummit.com

http://robwunderlich.com

View solution in original post

6 Replies
jpapador
Partner - Specialist
Partner - Specialist

On the sort tab do you have "State" unchecked?

Not applicable
Author

PHProp.PNG

is like this

jpapador
Partner - Specialist
Partner - Specialist

Uncheck the "State" option, currently in your image it is checked.

Not applicable
Author

but I changed and is the same thing

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I believe the issue is your sort expression "=orw". When you make selections, some of the orw values are no longer included. They compute to null which sorts them to the top of the list.

The solution is to use a set as your sort expression that ignores selections.

=sum({1}orw)

-Rob

http://masterssummit.com

http://robwunderlich.com

Not applicable
Author

Thanks a lot Rob , this is the correct way