Help on how to add 1 to the default fiscal year created by qlikview component

[#1]

Hi,

I was wondering if anyone knoew of a best approach to add 1 to the actual fiscal year created by the qlikview component.

For example. Creating caelndar qith QVC setting start of month as september (9)

This is how it would create the dates.

Original Date	Fiscal Year
8/1/2012	2011
9/1/2012	2012
10/1/2012	2012
11/1/2012	2012
12/1/2012	2012
1/1/2013	2012
2/1/2013	2012
3/1/2013	2012
4/1/2013	2012
5/1/2013	2012
6/1/2013	2012
7/1/2013	2012
8/1/2013	2012
9/1/2013	2013

The following is how I would like the scrip to create the fiscal year.

Original Date	Fiscal Year
8/1/2012	2012
9/1/2012	2013
10/1/2012	2013
11/1/2012	2013
12/1/2012	2013
1/1/2013	2013
2/1/2013	2013
3/1/2013	2013
4/1/2013	2013
5/1/2013	2013
6/1/2013	2013
7/1/2013	2013
8/1/2013	2013
9/1/2013	2014

Any help would be appreciated,

Thanks.

[#2]

maybe you can find something inspiring  in this recent blog post :

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

[Gysbert_Wassenaar · Accepted solution]

Try an offset of -3 instead of 9: call qvc.calendarfromfield('MyDate','FiscalCalendar',,-3);

[#4]

Do I understand it right that you want Fiscal Year to be exactly + 1 to year generated by QVC? Why not just add FY+1 as additional field after calendar was generated by QVC?

Calendar:

Join (Calendar) LOAD

     FiscalYear,

     FiscalYear + 1 as NewFiscalYear

RESIDENT Calendar;

[#5]

Thanks for the reply.

The thing is I already had FiscalYear in many of the controls and so it would mean I would have to change all the controls where I ave used FiscalYear.

"Try an offset of -3 instead of 9: call qvc.calendarfromfield('MyDate','FiscalCalendar',,-3);" worked for me.

[#6]

Thanks! This is what I was looking for.

Again thanks for the reply.