https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204286#M61258 <HTML><HEAD></HEAD><BODY><P>what is the easiest way to calculate rolling weeks?</P></BODY></HTML> Tue, 06 Apr 2010 17:43:22 GMT 2010-04-06T17:43:22Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204286#M61258 <HTML><HEAD></HEAD><BODY><P>what is the easiest way to calculate rolling weeks?</P></BODY></HTML> Tue, 06 Apr 2010 17:43:22 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204286#M61258 2010-04-06T17:43:22Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204287#M61259 <HTML><HEAD></HEAD><BODY><P>Hi Pritanya:</P><P>Can you explain us what do you mean with rolling weeks? Give us a little more information to try to help you</P><P>Regards,</P><P>Carlos</P></BODY></HTML> Tue, 06 Apr 2010 19:26:49 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204287#M61259 2010-04-06T19:26:49Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204288#M61260 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 07 Apr 2010 00:40:57 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204288#M61260 johnw 2010-04-07T00:40:57Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204289#M61261 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 07 Apr 2010 10:55:46 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204289#M61261 2010-04-07T10:55:46Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204290#M61262 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would use Set Analysis with an expression such as (where vWeek is the variable for the current week):</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">sum( {$&lt;Week = {$(#=vWeek-3)} + {$(#=vWeek-2)} + {$(#=vWeek-1)} {$(#=vLastYear)}&gt;} Sales )</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Wed, 07 Apr 2010 12:44:56 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204290#M61262 2010-04-07T12:44:56Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204291#M61263 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I believe rangeavg function in qlikview will solve the problem.</P><P>best regards,</P><P>Gaurav</P></BODY></HTML> Wed, 07 Apr 2010 12:58:21 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204291#M61263 2010-04-07T12:58:21Z https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204292#M61264 <HTML><HEAD></HEAD><BODY><P>can i get an example of the rangeavg in relation to weeks</P></BODY></HTML> Wed, 07 Apr 2010 15:06:31 GMT https://community.qlik.com/t5/QlikView/Rolling-weeks/m-p/204292#M61264 2010-04-07T15:06:31Z