topic Comparison Data in QlikView

Comparison Data

Tue, 24 Aug 2010 16:40:57 GMT

I have a requirement to show Total Sales for the past 12 months, Total Sales for the past 6 months, and Total Sales for the current month, with a comparison to the same time frame from the prior year. I can't seem to figure out the best way to get there. Does anyone have any ideas?

Comparison Data

Tue, 24 Aug 2010 16:57:20 GMT

It can be something like this:

sum({1 <Date={"$(='>=' & AddMonths(min({$} Date), -12) & '<=' & AddMonths(max({$}Date), -12))"}>} Amount)

Comparison Data

Thu, 26 Aug 2010 19:23:48 GMT

Nick,

Thank you for your quick reply. I was out of the office when this came in. Is there a way I could pick your brain to understand some of the code you wrote. This did look like a reasonable solution, just trying to wrap my head around it.

Rick

Comparison Data

Thu, 26 Aug 2010 19:54:55 GMT

It will be easier if you ask a question. The expression which I've provided is pretty straight forward. All what you need is just to replace a calculation of start and end dates for a necessary period:

<pre>sum({1 <Date={"$(='>=' & date(Start date here) & '<=' & date(End date here))"}>} Amount)

Comparison Data

Fri, 27 Aug 2010 20:49:28 GMT

Nick,

I think I figured it out, the second time you sent with a bit more explanation helped.

Rick