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.
Hi Sandra,
I have used Only({1}FiscalMonth) in my case. Thanks for the tip.
Regards
Mahesh Gadde
Very neat and thoughtful. Thanks for sharing.
Try this in your Sort tab -> Expr ->
= Rank(Only({1}Base_YRMonthSort)
Ref: Picked from one of Sunny's Expression solution.
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
Hi Martha,
Please see images below, both works fine!
Thanks,
Carlos M
Worked perfect in my case, thank you very much!