topic Fiscal Year Variable in QlikView

Fiscal Year Variable

WernerDC — Tue, 04 May 2021 07:59:46 GMT

Hi Guys, I hope you can help me. I have these variables in a App.

let vDateToday = date(floor(now()));
let vDateStartMTD = date(makedate(year(vDateToday),month(vDateToday),1));
let vDateStartYTD = date(makedate( if( month(vDateToday)<=2,year(vDateToday)-1,year(vDateToday) ), 3, 1 ));
let vDateStartYTDPY = date(makedate( if( month(vDateToday)<=2,year(vDateToday)-1,year(vDateToday)-1 ), 3, 1 ));
let vDateEndYTDPY = date(MonthEnd(makedate( if( month(vDateToday)<=2,year(vDateToday)-1,year(vDateToday) ), 2, 1 )));

How do I create one that looks at the Financial year as a whole? I want to create a button than says Full Financial year!

I currently have Year to Date , Year to date - Prior Year & Month to Date. I want to create a (Full Financial Year Button)

Hope you can help me

Re: Fiscal Year Variable

Dalton_Ruer — Wed, 05 May 2021 17:23:45 GMT

If you look at the function InYearToDate you will see that you can set the period for when your fiscal year begins.

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/inyeartodate.htm

You can add that as another flag in your load script that relates to the Fiscal Year.

Re: Fiscal Year Variable

WernerDC — Tue, 11 May 2021 08:19:57 GMT

Hi, thank you. Can you maybe provide me with an example?

Our Fiscal Year runs from 1-March to 29-Feb each year.

Kind regards

Re: Fiscal Year Variable

Dalton_Ruer — Tue, 11 May 2021 12:55:24 GMT

Here are a whole bunch of samples. Search for InYearToDate and you will see example of Fiscal Year in October (month 10)