Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
danielle_v
Creator
Creator

Change Month Dimension Sort Order in Chart

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!

1 Solution

Accepted Solutions
tresesco
MVP
MVP

try this:

Sort by expression (ascending):

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

View solution in original post

2 Replies
tresesco
MVP
MVP

try this:

Sort by expression (ascending):

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

View solution in original post

danielle_v
Creator
Creator
Author

Perfect, many thanks for your help!!