topic Re: Fiscal year in QlikView

Fiscal year

bhargavreddy127 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Sun, 05 Aug 2018 07:28:35 GMT

Check these:

sibin_jacob — Sun, 05 Aug 2018 11:09:58 GMT

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