Reporting using A Fiscal Calendar (4-4-5)

tmumaw — Fri, 21 Aug 2009 02:07:02 GMT

Hello all,

I am trying to calculate my ytd sales for the following:

Jan 2005 - Aug 2005 Jan 2006 - Aug 2006 Jan 2007 - Aug 2007 Jan 2008 - Aug 2008 Jan 2009 - Aug 2009

I am using the following statements :

Sum(IF(InYearToDate ([Billing Date], Today() , -4), [Inv Gross])) (2005)

Sum(IF(InYearToDate ([Billing Date], Today() , -3), [Inv Gross])) (2006)

Sum(IF(InYearToDate ([Billing Date], Today() , -2), [Inv Gross])) (2007)

Sum(IF(InYearToDate ([Billing Date], Today() , -1), [Inv Gross])) (2008)

Sum(IF(InYearToDate ([Billing Date], Today() , -0), [Inv Gross])) (2009)

My problem is we are on a 4-4-5 calendar. Example the first week of sales for Jan 2009 go to the last week of sales for 2008. How can I code this statment to support the above?

Thanks

Thom

topic Reporting using A Fiscal Calendar (4-4-5) in QlikView

Reporting using A Fiscal Calendar (4-4-5)