Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
daveamz01
Creator III
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))

View solution in original post