Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

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

Re: Financial Year

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

2 Replies
Not applicable

Re: Financial Year

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
Contributor II

Re: Financial Year

ta xx it works!!

Community Browser