Fiscal year

[bhargavreddy127]

Hi All,

Please help me out, My fiscal year starts from ever year 26 th march  

Eg:

25 - 03-2017 is 2016 to 2017

26-03-2017  is  2017 to 2018

Thanks in advance .

Regards

Bhargav

[BalaBhaskar_Qlik]

Check these:

Master Calendar for Fiscal Year starting April

https://community.qlik.com/docs/DOC-7094

https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

[sibin_jacob · Accepted solution]

Please use the below script to get the fiscal year

if(Month(Date_cloumn)>3,year(Date_column)&' to '&year(Date_column)+1,

if(Month(Date_cloumn)<3,year(Date_column)-1&' to '&year(Date_column),

if(Month(Date_cloumn)=3 and Date(Date_column,'DD')<=25,

year(Date_column)-1&' to '&year(Date_column),

year(Date_column)&' to '&year(Date_column)+1

))) as Fiscal_Year