Quarter over Quarter Comparison

[sspringer]

Please help - I am trying to show a year over year comparison (by Quarter).  I have a chart built that shows spend by Office Location.

I'm using the following to try and determine the total Charges for the selected quarter, or most recent quarter, LAST YEAR:

=sum({$<CalendarQuarterMonthsAndYear={"$(=QuarterName(max(DateInvoice),-4))"}>}ChargeNet)

and the same quarter for THIS YEAR:

=sum({$<CalendarQuarterMonthsAndYear={"$(=QuarterName(max(DateInvoice)))"}>}ChargeNet)

Unfortunately when I select a quarter or year at the top of the QVW I'm getting all kinds of odd results.  It isn't showing the most recent quarter for comparison.

Similarly, I'm using =QuarterName(max(DateInvoice),-4)  as my headers, and those aren't working right either.  When I select "Q4" from a list box it reads "Jan-Mar 2012" instead of "Oct-Dec 2012" like I need.

Please help.  Thank you,
Scott

[rwunderlich]

You may want to try the Calendar provided with Qlikview Components (Qvc). Qvc provides automatic variables for QTD and Previous Year QTD as well as other common periods. Qvc is a free open source QV script library and is available at http://qlikviewcomponents.org.

For an example of period analysis using Qvc, see http://qlikviewnotes.blogspot.com/2012/01/easy-period-analysis-using-qlikview.html

-Rob