Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maternmi
Creator II
Creator II

to order months according fiscal year

Hello,

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?

Thanks!

Best regards,

Michael

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Or, if you want adhoc front-end solution, try sort order expression like:

=Match(MonthField, 'Apr', 'May', 'Jun', 'July', ...)

Or,

If(Num(MonthField)<4, Num(MonthField)+12, Num(MonthField))

View solution in original post

3 Replies
Gysbert_Wassenaar

See this blog post: Fiscal Year


talk is cheap, supply exceeds demand
daveamz
Partner - Creator III
Partner - Creator III

Hello Michael,

You can assign the order with a inline table like:

LOAD * Inline [

FiscalMonth, Order

201304, 1

201305, 2

.....

];

and then sort it by Expresion: Order

Best regards,

David

tresesco
MVP
MVP

Or, if you want adhoc front-end solution, try sort order expression like:

=Match(MonthField, 'Apr', 'May', 'Jun', 'July', ...)

Or,

If(Num(MonthField)<4, Num(MonthField)+12, Num(MonthField))