Months that load out of order...

[#1]

Folks,

I want my Month selection box to read Jan, Feb, Mar, Apr, etc.  However, since our fiscal year starts in October, sorting the months by load order gives me Oct, Nov, Dec, Jan.  Any way around this?

Thanks,

R.

[Josh_Good · Accepted solution]

Yes there are several ways around this.  If your months are actually numeric and being displayed as text then if you sort by "Numeric Value".  If that doesn't work you can load an inline table of just the months in the correct order and then drop the table after you load your data.  This cause the load order to be in the order you desire.  If all else fails you can create a new field for month sort order and then sort the months based on that field.

[swuehl]

Yes, use QV calendar functions like Month() to create values derived from dates that you can easily sort as human beings expect. Check also http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/13/dual to learn more about the dual nature of QV values.

[Clever_Anjos]

Maybe this code can help you, generating a FiscalYear field that respects your need

LOAD

  Month,

  year(AddMonths(Month,3)) as FiscalYear;

LOAD

  date(AddMonths(Today(),-RecNo()),'MMM/YYYY') as Month

autogenerate 36

[#5]

Thanks, that worked!