Rolling Avg Weekly Sales dynamic

avastani — Thu, 24 Oct 2013 02:33:29 GMT

Is it possible to do a dynamic Rolling Avg in an expression? User can specify a parameter which will require the metric to show a dynamic Average Weekly Sales. A Time Dimension may or may not be present in the chart therefore, it must be intelligent enough to do

SUM(Sales for last n Periods)/n Periods

to yield that number

1. If a time period is not selected, then it would pick the most recent n Periods of sales,

2. else if selected, then use those n periods starting with the max date as the nth period,

3. else if time period is in the chart, then as per the definition of n prior periods

Not to mention there could be additional supporting dimensions of the Product Hierarchy, Customer Hierarchy etc.

topic Rolling Avg Weekly Sales dynamic in QlikView

Rolling Avg Weekly Sales dynamic