topic Re: Change Month Dimension Sort Order in Chart in QlikView

Change Month Dimension Sort Order in Chart

danielle_v — Thu, 01 Aug 2013 08:09:37 GMT

Hi All,

I have a line chart where the dimension is Month. Naturally, the sort order of this is Jan-Dec.

However, I'd like to change the sort order so that the months run from Sep-Aug. Is this possible?

The reason I'd like to do this is because my fiscal year runs from Sep-Aug - in the script, year is defined as right(yearname(DateField,0,9),4)

Any help greatly appreciated!

tresB — Thu, 01 Aug 2013 08:19:40 GMT

try this:

Sort by expression (ascending):

Expression like: match(MonthField, 'Sep', 'Oct', 'Nov', 'Dec',....,'Aug')

danielle_v — Thu, 01 Aug 2013 09:08:56 GMT

Perfect, many thanks for your help!!