Discussion board where members can get started with QlikView.
I have a posting Year field that starts in Aug and ends in Jul however the sorting order is Jan to Dec, is there a way I can change this and where would I change it? in the expression properties or the main scripting area.
Thanks in Advance
Go to Solution.
you can set sorting to be an expression and use match function. The in the following example the match will return 1 if month=Aug, 2 if month=Sep etc.
Hope this helps!
Perfect! Thanks a bunch Stefan, Highly Appreciated!
U can also add a field in the calender table like
If(Num(Month(TempDate))>=8 AND Num(Month(TempDate))<=12,(Num(Month(TempDate))-7),(Num(Month(TempDate))+5)) AS MonthNumber
After Reload, go in Sort expression and sort by MonthNumber.
This field will help u in other charts also..
Hope this helps..