topic Re: Four Week Average at Script Level in QlikView

Four Week Average at Script Level

Sun, 14 Oct 2012 08:43:22 GMT

Hello Stefan,

Script is working fine for the example you had shared earlier where I had numbers.

However when i apply the same script to big numbers i am not getting the desired results in QV.

I have attached excel file for your reference, where red font shows the results coming for four week averages in QV. And below is the script used.

LOAD

[Fiscal Week Ending],
[Sales Out $],
Rangesum([Sales Out $],peek([Sales Out $],-1),peek([Sales Out $],-2),peek([Sales Out $],-3))as myRollingAvg

Request you to provide your view on this.

Nassar

Re: Four Week Average at Script Level

Gysbert_Wassenaar — Sun, 14 Oct 2012 09:02:40 GMT

I'm afraid you've done something wrong somewhere. If I load your Test rolling.xls in qlikview and use the load script you posted, the values are calculated correctly.

Re: Four Week Average at Script Level

Sun, 14 Oct 2012 10:12:12 GMT

Hello Gysbert

Thanks for your reply.

I have the new data in the excel sheet attached in another query i am going to post now.

I am not getting the correct results for this.

Kindly have a look and advice.

Nassar