Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Valued Contributor

How to creating a Fiscal Year

Hello All,

Is it possible to create a Fiscal Year based up on Valid From   to Valid To  Date range.

Thanks

3 Replies
Highlighted
jwjackso
Valued Contributor

Re: How to creating a Fiscal Year

Assuming your fiscal year is different from the calendar year.  For example if the valid dates are 01-Jun-17 to 31-May-18.  If this is fiscal year 17, then Year(01-Jun-17).  If this is fiscal year 18, then Year (31-May-18)

kunkumnaveen
Valued Contributor

Re: How to creating a Fiscal Year

Lets say I have a Date Range

                         

                  Valid from                      ValidTo

        

15-10-201502-07-2017

then it will fall under Fiscal year - 2016,  Fiscal Year -2017 and Fiscal Year-2018

jwjackso
Valued Contributor

Re: How to creating a Fiscal Year

You need to know 2 things.  When the fiscal year starts and if the fiscal year is for the current year for the next year.  In your example 15-10-2015 is Fiscal year - 2016, so your fiscal year is for the next year, 2016 instead of 2015.

For any date, if it is less than Oct 15th, the fiscal year is that date, Year(Date).  If the date is greater than or equal to Oct 15th, the fiscal year is the year of the date +1, Year(Date) +1.