topic Moving annual total in QlikView

Moving annual total

Fri, 18 Dec 2009 21:40:19 GMT

I am trying to display a moving annual total of sales data (i.e. the total sales of the last 365 days, or 52 weeks) as a function of of date (or week). I have all orderline information (sales amount, sales date, customer, product). I thought this would be easy, but I have already wasted a couple of hours without any progress. Does anybody have a suggestion?

Thanks, Marc.

Moving annual total

Fri, 18 Dec 2009 21:45:05 GMT

Hi Marc,

the attached example will, hopefully, give you an idea how it could work.

Good luck!

Rainer

Moving annual total

Fri, 18 Dec 2009 21:46:27 GMT

Hope the file is attached now.

Moving annual total

Fri, 18 Dec 2009 21:48:34 GMT

You will find the file using this link:

http://community.qlik.com/forums/t/23598.aspx

Rainer

Moving annual total

Fri, 18 Dec 2009 22:10:31 GMT

Rainer,

Thank you for the quick reply. Unfortunately, I have no clue as to how this would answer my question.

Maybe I should elaborate a bit. I want to make a line graph with invoicedate as the dimension. For each invoicedate, I want to plot the sum of the sales of the past 365 days. The issue I have trouble with is: how do I ignore the dimension (invoicedate) in the calculation?

Regards,

Marc

Moving annual total

Mon, 21 Dec 2009 16:39:51 GMT

Hi Marc,

here are another idea. Combined "Rangesum" and "Above" function.

Hope we are a step closer to solve your problem.

Good luck!

Rainer

Moving annual total

Mon, 21 Dec 2009 16:41:29 GMT

RangeSum

(Above(Sum(Value),

0,2

))

Moving annual total

Mon, 21 Dec 2009 16:44:08 GMT

It´s a bad system today!

RangeSum

(Above(Sum(Value),

0,2))

Rainer

Moving annual total

Tue, 22 Dec 2009 15:51:42 GMT

Hi,

hope the application is attached now.

Merry Christmas!

Rainer

Moving annual total

Sun, 27 Dec 2009 20:21:55 GMT

Hi Rainer,

Thanks a lot for the alternative solution. I think this might work. I am having some trouble accessing the data because of network issues, so I cannot try now. As soon as the problem is fixed, I will give your suggestion a try and will let you know.

Regards,

Marc.