Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

Financial Year

Hiya

I am using the code shown to render Financial Year as e.g 2013/2014  2014/2015

Year(addmonths(addyears([Order Date],1),-3)) &'/' & Year([Order Date])

when I do I get

2014/2013

2014/2014

2015/2014

2015/2015

appearing in the pane, I have also tried using the code in the master calendar

Year(addmonths(addyears([Order Date],1),-3)) &'/' & Year([Order Date]) as Financial Year and I get the same

I have tried to

Date(Floor("Order Date"))as "Order Date",

to see if it helps and still no joy

please help

1 Solution

Accepted Solutions
Not applicable

YEAR(ADDMONTHS([Order Date],-3)) & '/' & (YEAR(ADDMONTHS([Order Date],-3))+1)

so up to April, it takes the Financial year as the year before e.g. today would show as 2015/2016

View solution in original post

2 Replies
Not applicable

YEAR(ADDMONTHS([Order Date],-3)) & '/' & (YEAR(ADDMONTHS([Order Date],-3))+1)

so up to April, it takes the Financial year as the year before e.g. today would show as 2015/2016

joeybird
Creator III
Creator III
Author

ta xx it works!!