Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Please refer below posts:
Calculating rolling n-period totals, averages or other aggregations