Fisacl Year

[bhargavreddy127]

Hi Every one,

My fisacal year starts from ever year 26 th march .

How to create a fiscal year for this ?

Thanks,

Bhargav

[BalaBhaskar_Qlik]

Check these:

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

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

Master Calendar for Fiscal Year starting April

[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