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.
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
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 byExpression: 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!
