Moving annual total

[#1]

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.

[#2 · Accepted solution]

Hi Marc,

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

Good luck!

Rainer

[#3]

Hope the file is attached now.

[#4]

You will find the file using this link:

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

Rainer

[#5]

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

[#6]

Hi Marc,

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

Hope we are a step closer to solve your problem.

Good luck!

Rainer

[#7]

RangeSum

(Above(Sum(Value),(Above(Sum(Value),

(Above(Sum(Value),

0,2

))

[#8]

It´s a bad system today!

RangeSum

(Above(Sum(Value),(Above(Sum(Value),

(Above(Sum(Value),

0,2))

Rainer

[#9]

Hi,

hope the application is attached now.

Merry Christmas!

Rainer

[#10]

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.