Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using QlikView 11.20 SR2. I have a listbox that displays my fiscal months like this:
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(?)).
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?
It seems to me I've been able to do this before. Thanks for any help.
In the Expression box just say =
It will resolve your problem
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?
Please upload Qvw
Added qvw to original post.
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)
Hi,
If you use load order it should work fine.
thanks,
Rajesh Vaswani
Hi Martha,
See the attached document, its working, now it does not change order.
is this, what you was looking.
Regards
Khan
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
Hi
PFA hope this will helps you