Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
danielle_v
Contributor

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
Highlighted
MVP
MVP

Re: Change Month Dimension Sort Order in Chart

try this:

Sort by expression (ascending):

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

2 Replies
Highlighted
MVP
MVP

Re: Change Month Dimension Sort Order in Chart

try this:

Sort by expression (ascending):

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

danielle_v
Contributor

Re: Change Month Dimension Sort Order in Chart

Perfect, many thanks for your help!!

Community Browser