topic Re: Sorting Listbox in QlikView

Sorting Listbox

sibin_jacob — Sun, 17 Feb 2013 11:14:17 GMT

Hai,

I want to sort listbox in a specified order. Filed name for the list box is 'Decile_Type' and the values are High, Medium , Low.

I can' change the order in backend. I want it in the same order (High, Medium, Low). I Can't Use load order.

Is it possible to sort the listbox in specified order ?

Is it possible to achieve this sort order using 'sort by expression' option?

Thanks,

Sibin Jacob.C

Re: Sorting Listbox

swuehl — Sun, 17 Feb 2013 12:02:13 GMT

Try a sort by expression like

=match(Decile_Type,'High','Medium','Low')

If you say you can't change order in the backend, that means you don't have access to the script / you can't change the script?

If you do have access to the script, there are several methods to prepare your field sorting in the script, so you don't need a sort by expression in the UI, at different places.

Re: Sorting Listbox

sibin_jacob — Mon, 18 Feb 2013 07:26:57 GMT

Thank you Swuehl. It is working Fine.

Regards,

Sibin Jacob.C