52week rolling period

Mon, 24 Nov 2014 15:31:14 GMT

Hi all,

I am trying to create a pivot table containing a 52 week rolling period. I already made a start in the added file containing a rolling period of 4 weeks. But I can't get it to work. (Amount of used trucks are not used the file)

The formula needs to show me:

Average km per week:'Total km per week / total trucks used that week'. And then the total of 52 week averages.

For example when 1-1-2014 starts I want it to show me the total of all calculations of the last 52 weeks.

Example:

Week

2014-1 shows week 2013-1 up to 2013-52

2014-2 shows week 2013-2 up to 2014-1

2014-3 shows week 2013-3 up to 2014-2

etc etc.

I hope someone can help me with this problem!!

Kind regards,

Vincent

topic 52week rolling period in QlikView

52week rolling period