Quarter over Quarter Comparison

sspringer — Fri, 01 Jun 2012 14:03:13 GMT

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

Quarter over Quarter Comparison

rwunderlich — Fri, 01 Jun 2012 17:43:16 GMT

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

topic Quarter over Quarter Comparison in QlikView

Quarter over Quarter Comparison

Quarter over Quarter Comparison