Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator II

ListBox keep sort order after selection?

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

1 Solution

Accepted Solutions
felipedl
Partner
Partner

Hi Phil,

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

Example with Ascending (keeps the selection on top):

Sample.png

Auto (keeps the selection order):

Sample2.png

Felipe.

View solution in original post

4 Replies
felipedl
Partner
Partner

Hi Phil,

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

Example with Ascending (keeps the selection on top):

Sample.png

Auto (keeps the selection order):

Sample2.png

Felipe.

View solution in original post

prees959
Creator II
Creator II
Author

Thanks very much!

Kush
MVP
MVP

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
Partner
Partner

Glad it helped Phil .