Discussion Board for collaboration related to QlikView App Development.
I want to reorder the months of a calendar year according our fiscal year, which starts with April and ends with March.
How can I do it in a list box?
Or, if you want adhoc front-end solution, try sort order expression like:
=Match(MonthField, 'Apr', 'May', 'Jun', 'July', ...)
If(Num(MonthField)<4, Num(MonthField)+12, Num(MonthField))
View solution in original post
See this blog post: Fiscal Year
You can assign the order with a inline table like:
LOAD * Inline [
and then sort it by Expresion: Order