Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mjt_childrens
Contributor III
Contributor III

Maintain Month order in listbox after selections

I'm using QlikView 11.20 SR2.   I have a listbox that displays my fiscal months like this:

PIC1.PNG

I want the months to stay in the order displayed above even after the user makes a selection.   But if I select Oct,Nov,Dec it puts these selections at the end of the listbox (and somehow Mar and Feb end up before Jan(?)).   

PIC2.PNG

Here is now I have my listbox sort properties set.  Base_YRMonthSort is a field created with year and month number (201309, 201310, etc).   What am I missing?

PIC3.PNG

It seems to me I've been able to do this before.   Thanks for any help.

15 Replies
Not applicable

In the Expression box just say =

It will resolve your problem

mjt_childrens
Contributor III
Contributor III
Author

PIC4.PNG

Thanks for the speedy reply.   It solves one problem but creates another -- now my months aren't in order from Oct - Sep.

Isn't there a way to tell QV how to sort my values but don't change the order based on the selections?

Not applicable

Please upload Qvw

mjt_childrens
Contributor III
Contributor III
Author

Added qvw to original post. 

Not applicable

Hi,

Just had the same problem and think the sorting is done over the possible field values, so if they are cleared in the expression it should work. I don't know the intended way to do this, but it works by using an aggregation function and add a set expression to it that clears all selections.

In your case you can use this as sort expression: =Min({1}Base_YRMonthSort)

rajeshvaswani77
Specialist III
Specialist III


Hi,

If you use load order it should work fine.

thanks,

Rajesh Vaswani

israrkhan
Specialist II
Specialist II

Hi Martha,

See the attached document, its working, now it does not change order.

is this, what you was looking.

Regards

Khan

Not applicable

Hi Martha,

Mr. Khan has given right solution.

On continution further,The definite way for this type of problem  is let QlikView use origanal load order.So that, even after selection of any month, order doesn't changes.

Thankx Mr.Khan.

-Regards,

Kiran

Not applicable

Hi

PFA   hope this will helps you