Discussion Board for collaboration related to QlikView App Development.
I need to amend the following code which currently works out a standard calendar year to a fiscal calendar year which runs from 1st July to 30th June. Your input is appreciated.
,Month($(vCalendarDate)) as MONTH
,Year($(vCalendarDate)) as YEAR
,('Q'&Ceil(Month($(vCalendarDate))/3)) as QUARTER
check out the attached which contains a standard fiscal Calendar, you should be able to tweak it to fit!
Something like this:
,Year(YearStart($(vCalendarDate), 7)) As FiscalYear
,Mod(Num(Month($(vCalendarDate))) + 5, 12) + 1 As FiscalPeriod
,'FQ' & Ceil((Mod(Num(Month($(vCalendarDate))) + 5, 12) + 1)/3) As FiscalQuarter
Thanks Jonathon. That just adds 7 years onto each year rather than start a new year if it reaches the 7th month