topic Re: Fisacl Year in QlikView

Fisacl Year

bhargavreddy127 — Sat, 04 Aug 2018 11:47:24 GMT

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

Check these:

sibin_jacob — Sun, 05 Aug 2018 11:10:30 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