Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
genovese
Partner - Contributor II
Partner - Contributor II

always one selected sort order

Hello guys,

The always one selected is a very nice feature!

Now my question: I have a client who wants to have a special sorting of his different companies in the selection bar. Is it possible to change the sort order of the field you use for "always one selected"?

How it is currently:
Alpha Company
Beta Company
Gamma Company
Zeta Company

How it is desired:
Beta Company (Sortorder ID: 1)
Zeta Company (Sortorder ID: 2)
Alpha Company (Sortorder ID: 3)
Gamma Company (Sortorder ID: 4)

Thx for every helpful comment

Best regards,

Dario

Labels (2)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Havent tested it but try to define the column as a dual with string and numeric value

View solution in original post

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

Havent tested it but try to define the column as a dual with string and numeric value
genovese
Partner - Contributor II
Partner - Contributor II
Author

Tested and it works with dual 🙂

dual(company,SortOrderID) as Company

Thank you very much!

dplr-rn
Partner - Master III
Partner - Master III

glad to help
anderseriksson
Partner - Specialist
Partner - Specialist

You could also make sure they are loaded in the load script in the order you want and then sort by load order.
This is good if you cant use duals or change the value of fields.
Note that the load order is set the first moment a field is loaded.
Rearranging the order in a later statement in the load script by using load 'field' resident 'table' order by 'something' won't work.