20 Week rolling

[#1]

Hi all,

I am buildling a 20 week average that moves over the years. To make this happen I made an excel file containing 2 rows:

20 week average     20 Weeks

2016-2                    2016-2

2016-2                    2016-1

2016-2                   2015-53

2016-2                    2015-52

Etc etc etc

This would be week 2016-2 is 20 weeks back, week 2016-1 and 20 weeks back etc etc.

However I got 2 problems:

- 1 I was wondering if its possible to let Qlikview calculate these rows instead of building this in excel for all my weeks.

- 2 How could I connect/add this? I already got my QV app but I need to add/intergrate this function to the existing data structure.

Kind regards,

[MK_QSL]

Based on the data you have provided,

you can simply create a Straight Table

Dimension

[1/20Week]

Expression

SUM(Hours)
SUM(Workers)

[#3]

Hi Manish,

I was wondering if its possible to let Qlikview develop this. Now I manually produced this by marking the year-weeks which needed to be marked as data for 2016-1 or 2016-2.

2nd if I would create a table marking which weeks would be collected per rolling 20 weeks how should I use this data in a pivot table to give me the much needed 20 weeks rolling?

[MK_QSL]

What QV can handle and what can't ... would be answered only if you provide proper raw data...

[#5]

HI,

    Just let me know which calendar fields u have like, Year , Week , Year-Week

It looks like you need to generate [1/20Week] field data which will further comes along with [20Week] respect to Hour & Worker data to present report like below,

	Hours	Workers
2016-1	524	220.7143
2016-2	762.8571	592.1429
2016-3	1105.714	963.5714
2016-4	1448.571	1335

Is this what you're looking for ?

Regards,

[#6]

Hi,

Yes it needs to sum but also over the past year. So 2016-1 would calculate 19 weeks from 2015 & 1 week from 2016.

Kind regards.