Rolling Sales Calculation

Thu, 19 Feb 2015 00:38:01 GMT

Hi,

I am trying to calculate Previous 13 weeks sales column in Qlikview. I am using rangesum and above function. The limitation of this

is at the beginning of the time period the calculation is incorrect as there no previous 13 data points. My question is :

1) Is there any way i can create sum of previous weeks column without impacting the staring point?

I need last 13 weeks calculation data, so I am okay if there is a way to visually hide the previous weeks. Please note I need it in Pivot table, as I need to add more dimensions later in actual project. I thought of using Cumulative function but there is no such option Pivot table.

Attached is the Qlikview File.

Any help would be appreciated!

Re: Rolling Sales Calculation

AbhijitBansode — Thu, 19 Feb 2015 05:42:48 GMT

Please refer below posts:

Calculating rolling n-period totals, averages or other aggregations

Accumulative Sums

topic Rolling Sales Calculation in QlikView

Rolling Sales Calculation

Re: Rolling Sales Calculation