Creating a 14-month time period

burgersurfer — Tue, 27 Nov 2012 16:24:05 GMT

I have a QV document in which the fiscal year is defined from June > May. All reporting is done off this FY, but managers now want to expand on this time period to include 2 previous months, making the reporting period from e.g. April 2011 > May 2012. This will therefore include data from FY2011 (the two months April and May 2011), and the twelve months from FY2012.

How do I define a 14-month "year" in QV?

My script currently creates the FY as follows:

TempDate AS CalendarDate,

If(Month(TempDate) > 5, Month(TempDate)-5, Month(TempDate)+7) as FinMonth,

.....

Thanks!

Re: Creating a 14-month time period

Wed, 28 Nov 2012 07:42:30 GMT

Try this one:

TempDate AS CalendarDate,

If(Month(TempDate) > 3, Month(TempDate)-3, Month(TempDate)+11) as FinMonth

topic Creating a 14-month time period in QlikView

Creating a 14-month time period

Re: Creating a 14-month time period