topic Re: ListBox keep sort order after selection? in QlikView

ListBox keep sort order after selection?

prees959 — Fri, 29 Sep 2017 12:08:30 GMT

Hi, I have a Month listbox which is sorted using

=match(Month, 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

in the expression box. If a month is selected can the sort order be kept? At the moment, if a month is selected it moves to the top of the listbox.

Many thanks,

Phil

felipedl — Fri, 29 Sep 2017 12:29:53 GMT

Hi Phil,

On the Sort tab of the list box, use the Auto Ascending in state.

Example with Ascending (keeps the selection on top):

Auto (keeps the selection order):

Felipe.

prees959 — Fri, 29 Sep 2017 12:51:58 GMT

Thanks very much!

Kushal_Chawda — Fri, 29 Sep 2017 12:55:18 GMT

one more option

Try uncheck all sort option, keep only expression, with below expression

=match(only({1}Month), 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

felipedl — Fri, 29 Sep 2017 13:03:47 GMT

Glad it helped Phil .