Discussion Board for collaboration on QlikView Layout & Visualizations.
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!
Go to Solution.
Sort by expression (ascending):
Expression like: match(MonthField, 'Sep', 'Oct', 'Nov', 'Dec',....,'Aug')
Perfect, many thanks for your help!!