topic Re: List Box Sort by expression with excluded item at the bottom in QlikView

List Box Sort by expression with excluded item at the bottom

Mon, 24 Mar 2014 18:13:55 GMT

I need to sort a list box in alphabetical order, but the available items (white items) need to be listed at the top (A-Z) and the excluded items (grayed-out items) need to be listed at the bottom (A-Z). How would I do this?

Re: List Box Sort by expression with excluded item at the bottom

Luis_Cortizo — Mon, 24 Mar 2014 18:23:25 GMT

I'm not sure if have understood the question, that's the default sort behavior of a list box (white on top grey at bottom).

Check that you are using this configuration on the Sort tab:

Re: List Box Sort by expression with excluded item at the bottom

maxgro — Mon, 24 Mar 2014 18:25:43 GMT

in sort tab

state ascending

text A-->Z

or I'm missing something?

Re: List Box Sort by expression with excluded item at the bottom

Mon, 24 Mar 2014 18:34:43 GMT

You guys are absolutely correct, I didn't have State Ascending selected.

Curious, what is the difference between Auto Ascending and Ascending?

Re: List Box Sort by expression with excluded item at the bottom

Luis_Cortizo — Mon, 24 Mar 2014 18:38:14 GMT

Auto ascending sort the list box only if it has a vertical scroll bar otherwise it doesn't do anything.

You can test it with a list box of let's say... ten values, show on screen only five with the vertical scroll bar and then, re-size the listbox to show every value (it stops sorting)