topic Re: Custom order in listbox issue in QlikView

Custom order in listbox issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Custom order in listbox issue

vishsaggi — Sat, 30 Sep 2017 02:48:55 GMT

Try these settings in your Sort tab of Listbox.

Re: Custom order in listbox issue

dinuwanbr — Sat, 30 Sep 2017 05:26:55 GMT

Hi,

PFA

Rgds,

Tharindu

Re: Custom order in listbox issue

its_anandrjs — Sat, 30 Sep 2017 05:47:14 GMT

Hope you are looking for this

In sort properties of list object try

=Only({1} [Country Order])

Re: Custom order in listbox issue

Anonymous — Mon, 02 Oct 2017 12:30:32 GMT

Thanks a lot guys!

Re: Custom order in listbox issue

vishsaggi — Mon, 02 Oct 2017 15:43:52 GMT

YOu did not find the answer what you looking for?

Re: Custom order in listbox issue

Colin-Albert — Mon, 02 Oct 2017 20:27:43 GMT

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()