Rolling weeks

[#1]

what is the easiest way to calculate rolling weeks?

[#2]

Hi Pritanya:

Can you explain us what do you mean with rolling weeks? Give us a little more information to try to help you

Regards,

Carlos

[johnw]

As a guess, I assume you have a chart with dates on the axis, but you want, say, the sum of sales for the last seven days for each date? The easiest way is to go to the Expressions tab, and select Accumulate, and select 7 steps back.

[#4]

i'm am trying to create a chart in order to show a 4 week rolling total. the chart should be able to show me the total for the week commencing and the previous three weeks

[#5]

Hi,

I would use Set Analysis with an expression such as (where vWeek is the variable for the current week):

sum( {$<Week = {$(#=vWeek-3)} + {$(#=vWeek-2)} + {$(#=vWeek-1)} {$(#=vLastYear)}>} Sales )

[#6]

Hi,

I believe rangeavg function in qlikview will solve the problem.

best regards,

Gaurav

[#7]

can i get an example of the rangeavg in relation to weeks