topic Re: rolling time frame in QlikView

rolling time frame

Anonymous — Fri, 10 Apr 2015 23:58:12 GMT

i am trying to create a rolling 13 wk period for item, store and date within a straight table. This requires the three as dimensions, and the date to be the maximum range of the 13 wk period. i have had some success with the most current date, but want make sure that it is incremented trough time within the same table.

datekey start end exp1

201412 201401 201412 sum({last 13 wks total sales}totalsales)

201413 201402 201413 sum({last 13 wks total salestotalsales)

201414 201403 201414 sum({last 13 wks total salestotalsales)

any thoughts would be apprciated.

Re: rolling time frame

ecolomer — Sun, 12 Apr 2015 07:31:03 GMT

Can you explain more your requeriment?, please

Re: rolling time frame

maxgro — Sun, 12 Apr 2015 07:54:23 GMT

read this (above all AsOf table)

https://community.qlikview.com/docs/DOC-4252

Re: rolling time frame

Anonymous — Sun, 12 Apr 2015 14:55:00 GMT

I can. with the dimensions of item store date, I need the sum of the previous thirteen weeks; a rolling total. Not long after I posted my request, I ran across this link Calculating rolling n-period totals, averages or other aggregations, and it seems to be the right answer. It also appears to be Massimo's suggestion. Thank you both for your time. If you have another approach, I would be happy to hear it.