Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Fiscal calendar beginning July 1

Hi

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


Thanks

Sid.

3 Replies
Highlighted
Partner
Partner

Re: Fiscal calendar beginning July 1

Hi Sid,

check out the attached which contains a standard fiscal Calendar, you should be able to tweak it to fit!

Highlighted
MVP
MVP

Re: Fiscal calendar beginning July 1

Something like this:

,Month($(vCalendarDate)) as MONTH

,Year($(vCalendarDate)) as YEAR

,('Q'&Ceil(Month($(vCalendarDate))/3)) as QUARTER

,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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

Re: Fiscal calendar beginning July 1

Thanks Jonathon. That just adds 7 years onto each year rather than start a new year if it reaches the 7th month