topic Re: List box sorting in QlikView

List box sorting

Tue, 31 Jul 2012 12:24:26 GMT

I have a list box containing the values in the following format:

My 1st book

My 3rd book

My 2nd book

But i want to show my values in the listbox as:

My 1st book

My 2nd book

My 3rd book

I have tried all the sorting combination under the properties. I have created an expression for this listbox instead of using a field in the listbox.

Re: List box sorting

cesaraccardi — Tue, 31 Jul 2012 12:28:45 GMT

You can create an additional field in the load script for sorting, and use an expression for sorting like:

avg({1} Sorting_Field)

Re: List box sorting

swuehl — Tue, 31 Jul 2012 12:29:48 GMT

You probably already tried the Text sort option, this worked out for me, so I probably miss something essential in your setting. Could you post a small sample file?

Re: List box sorting

Tue, 31 Jul 2012 13:09:20 GMT

i have tried every combination in the sorting tab and one more thing, my list is multi coloumn. Please anyone suggest something. should i try sorting by expression? if yes, then what expression should i write?

Re: List box sorting

Tue, 31 Jul 2012 13:14:52 GMT

sort by expression

=num(keepchar (field1,'1234567890' ))

Re: List box sorting

swuehl — Tue, 31 Jul 2012 13:16:50 GMT

Maybe uncheck 'order by column' option in presentation tab? Can't reproduce your issue here.

Well, it's really hard to tell, you should at least post a screenshot and your expressions used, at best a small sample app.

Using QV11.

Regards,

Stefan

Re: List box sorting

Tue, 31 Jul 2012 13:27:48 GMT

Many thanks for the reply Pari, It worked for me. Can you Please tell me how to stop the self adjusting nature of list box, which is:

when you select a value in the list box, it goes tot he top or bottom.

Could you please help me on this?

Re: List box sorting

Tue, 31 Jul 2012 13:34:36 GMT

uncheck "sort by state"