topic Sort state on list box in QlikView

Sort state on list box

Tue, 05 Jul 2011 11:46:46 GMT

Hi everyone,

I have one field and a sort field:

Field, SortOrder

a, 1

t, 2

c, 3

g, 4

I use Field as my list box and for Sort I put an expression as:

=[SortOrder]

The problem is that when I select something it automatically drops to the bottom. If I deselect auto-ascending this doesn't fix it.

I know it's something simple I'm just missing!

Thanks

Gareth

Sort state on list box

raghavsurya — Tue, 05 Jul 2011 12:01:21 GMT

Hi Gareth,

Please check sort by field with Load Order and select original in the drop down. Also uncheck the Auto descending.

Regards,

Raghav

Sort state on list box

nagaiank — Tue, 05 Jul 2011 12:14:06 GMT

Is the sort priority set correctly?

You may also view http://community.qlik.com/message/129863#129863

Sort state on list box

Anonymous — Tue, 05 Jul 2011 12:49:14 GMT

If I remember correctly there was a bug with the sorting of listboxes when using the auto ascend and sorting by expression. You might want to check with QlikView support

Sort state on list box

Tue, 05 Jul 2011 12:52:26 GMT

Thanks for your suggestions the Load order is different to the order I want to have in my actual data.

e.g.:

Field, SortOrder

a, 1

t, 4

c, 3

g, 2

Sorry I selected a bad example.

As far as I can see there is no option to change the sort priority on list boxes. That link to a dual load example is interesting and works for the list boxes but then causes major problems throughout the rest of my report so not really going to work for me.

Cheers,

Re: Sort state on list box

prieper — Tue, 05 Jul 2011 12:59:38 GMT

What is wrong with it? - sample is attached

Peter

Sort state on list box

Tue, 05 Jul 2011 13:12:35 GMT

See how when you select one it jumps either to the top or the bottom? I want the order to remain the same. So if I select a I want it to remain a the top of the listbox. If I select c I want it to remain in the 3rd position.

Thanks

Re: Sort state on list box

prieper — Tue, 05 Jul 2011 15:43:59 GMT

mmmh

Have not noticed - believe it was different in previous versions...

(puzzled)

Peter