Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Four Week Average at Script Level

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

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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