topic Re: How to make listbox order static in QlikView

How to make listbox order static

Thu, 12 Apr 2012 10:37:21 GMT

I have created several listboxes however they behave differently. Example: I have one periode listbox and one account. Selecting a row in the periode listbox the order remains the same, however in the account listbox the selected row jumps up to the top.

How to make listbox order static

CELAMBARASAN — Thu, 12 Apr 2012 10:43:17 GMT

Hi,

Go to properties-->Sort tab-->un check the sort by state option... by default it is checked

Celambarasan

How to make listbox order static

Thu, 12 Apr 2012 10:50:24 GMT

It did help, however it was also, by default, checked on sort by numeric value. Account has datatype Varchar so i had to change from numeric - text. Thanks

Re: How to make listbox order static

lawrenceiow — Fri, 13 Dec 2013 16:00:01 GMT

I know you asked this ages ago but I had this problem too and after a lot of searching I noticed an option in the Sort tab that I hadn't considered before and ended up using this method as it works for me.

I wanted a list box with the following items in this order: Trend, Benchmark, Benchmarked Trend, Distribution.

As you can imagine the listbox put them in alphabetical order. I then had the idea to create a separate table of data and add a field to force the order (i.e. Sort by Expression: AnOrd):

Analysis:

LOAD * INLINE [

Analysis, AnOrd

Trend, 1

Benchmark, 2

B'mark Trend, 3

Distribution, 4

];

This worked as I needed until the user clicked Benchmark, for example, and this moved to the top of the list! Not what I wanted. After spending a lot of time with Google and not coming up with the answer (even here in the Community) I noticed that the Sort options had an item called Load Order. This worked - simple, wish I'd spotted it earlier!

Hope this works for you.