Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Custom order in listbox issue

Hello,

I'm trying to custom order for a field "Country" .

I did a mapping with the field "Country" and " Country Order"  like below:

Country  Country Order   

USA                 1

Canada            2 

Brazil                3

After loading, i use sort by expression in the listbox:

But the problem is : when i select a value in the listbox, the value selected goes to the end of the list. (i had some similar problem with the value selected goes to the top of the list ), as result, impossible to sort by expression.

I unchecked the box "State", but it does not work.

Any tips for this?

Thanks in advance!

6 Replies
Highlighted
Champion III
Champion III

Try these settings in your Sort tab of Listbox.

Capture.PNG

Highlighted
Creator III
Creator III

Hi,

PFA

Rgds,

Tharindu

Highlighted

Hope you are looking for this

In sort properties of list object try

=Only({1} [Country Order])

Highlighted
Contributor II
Contributor II

Thanks a lot guys!

Highlighted
Champion III
Champion III

YOu did not find the answer what you looking for?

Highlighted

Create the country field as a dual value with the text and numeric sort order.

The list box will display the text in numeric order without the need to change the sort sequence.

How to use- Dual()