Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bhargavreddy127
Contributor
Contributor

Fisacl Year

Hi Every one,

My fisacal year starts from ever year 26 th march .

How to create a fiscal year for this ?

Thanks,

Bhargav

1 Solution

Accepted Solutions
sibin_jacob
Creator III
Creator III

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

View solution in original post

2 Replies
sibin_jacob
Creator III
Creator III

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

View solution in original post