Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

In the Expression box just say =

It will resolve your problem

Highlighted
Contributor III
Contributor III

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?

Highlighted
Not applicable

Please upload Qvw

Highlighted
Contributor III
Contributor III

Added qvw to original post. 

Highlighted
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)

Highlighted
Specialist III
Specialist III


Hi,

If you use load order it should work fine.

thanks,

Rajesh Vaswani

Highlighted
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

Highlighted
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

Highlighted
Not applicable

Hi

PFA   hope this will helps you