topic Re: Maintain Month order in listbox after selections in QlikView

Maintain Month order in listbox after selections

mjt_childrens — Thu, 15 Aug 2013 20:17:05 GMT

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.

Re: Maintain Month order in listbox after selections

Thu, 15 Aug 2013 20:37:38 GMT

In the Expression box just say =

It will resolve your problem

Re: Maintain Month order in listbox after selections

mjt_childrens — Thu, 15 Aug 2013 20:43:43 GMT

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?

Re: Maintain Month order in listbox after selections

Thu, 15 Aug 2013 20:45:46 GMT

Please upload Qvw

Re: Maintain Month order in listbox after selections

mjt_childrens — Thu, 15 Aug 2013 21:23:27 GMT

Added qvw to original post.

Re: Maintain Month order in listbox after selections

Tue, 17 Sep 2013 15:02:03 GMT

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)

Re: Maintain Month order in listbox after selections

rajeshvaswani77 — Tue, 17 Sep 2013 15:07:30 GMT

Hi,

If you use load order it should work fine.

thanks,

Rajesh Vaswani

Re: Maintain Month order in listbox after selections

israrkhan — Tue, 17 Sep 2013 15:54:16 GMT

Hi Martha,

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

is this, what you was looking.

Regards

Khan

Re: Maintain Month order in listbox after selections

Fri, 10 Jan 2014 06:10:07 GMT

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

Re: Maintain Month order in listbox after selections

Fri, 10 Jan 2014 06:26:43 GMT

PFA hope this will helps you

Re: Maintain Month order in listbox after selections

gaddeonline — Mon, 25 Jul 2016 00:37:44 GMT

Hi Sandra,

I have used Only({1}FiscalMonth) in my case. Thanks for the tip.

Regards

Mahesh Gadde

Re: Maintain Month order in listbox after selections

montubhardwaj — Wed, 05 Apr 2017 17:42:35 GMT

Very neat and thoughtful. Thanks for sharing.

Re: Maintain Month order in listbox after selections

vishsaggi — Wed, 05 Apr 2017 17:55:50 GMT

Try this in your Sort tab -> Expr ->

= Rank(Only({1}Base_YRMonthSort)

Ref: Picked from one of Sunny's Expression solution.

Re: Maintain Month order in listbox after selections

jrepucci15 — Wed, 05 Apr 2017 18:11:14 GMT

Could use a Dual() function to assign 1 -> 12 to your fiscal months, then sort by numeric.

Dual(Pick(GlPeriold,'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep'), GlPeriod ) as Month

Re: Maintain Month order in listbox after selections

CarlosAMonroy — Wed, 05 Apr 2017 18:39:43 GMT

Hi Martha,

Please see images below, both works fine!

Thanks,

Carlos M

Re: Maintain Month order in listbox after selections

dapostolopoylos — Thu, 08 Jun 2017 07:04:40 GMT

Worked perfect in my case, thank you very much!