Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
[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
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.
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