topic Re: Add 6 weeks in QlikView

Add 6 weeks

gr_eldred — Tue, 18 Jul 2017 16:53:44 GMT

I have 52 weeks of the year 2017 in a simple table

I want to add 6 weeks sales.

If I arrive at week 6 of the 1 to the 6 is the sum, if I am in week 7 the sum is of week 2 to 7, etc.

Currently we are in week 29

Can somebody help me?

Re: Add 6 weeks

Anil_Babu_Samineni — Tue, 18 Jul 2017 17:04:42 GMT

I assume, You need set analysis to achieve this, May be try this?

Sum({<Week = {">=$(=Max(Week)-6) <=$(=Max(Week))"}>} sales)

Re: Add 6 weeks

gr_eldred — Tue, 18 Jul 2017 18:39:03 GMT

Hi, thank you for your help here, I'm just bringing the last 6 weeks of information, what I need is that in each week I get the total of the sum of 6 weeks ago.

sum({$<Status-={'C'}, SemamaAñoApple_Numerado = {">=$(=Max(SemamaAñoApple_Numerado)-6)<=$(=Max(SemamaAñoApple_Numerado))" }, Año={$(=only(Año))}>} Cantidad)

Example:

Week 6 must bring the sum of 6 weeks back (week1 + week2 + week3 + week4 + week5 + week6)

Week 7 has to show the sum of 6 weeks ago (week2 + week3 + week4 + week5 + week6 + week7)

Re: Add 6 weeks

MarcoWedel — Tue, 18 Jul 2017 23:52:51 GMT

Hi,

you could try with

RangeSum(Above(Sum(Sales),0,6))

and a week dimension in your straight table.

hope this helps

regards

Marco