Discussion Board for collaboration on QlikView Scripting.
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.
The following is how I would like the scrip to create the fiscal year.
Any help would be appreciated,
Go to Solution.
Try an offset of -3 instead of 9: call qvc.calendarfromfield('MyDate','FiscalCalendar',,-3);
maybe you can find something inspiring in this recent blog post :
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?
Join (Calendar) LOAD
FiscalYear + 1 as NewFiscalYear
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.
Thanks! This is what I was looking for.
Again thanks for the reply.