topic Re: Rolling Period with Average in QlikView

Rolling Period with Average

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have show rolling period for 3 months(which I knew) but at the same time we should show average for the 3 months like below in Pivot table/ if possible in straight table.

Expre: Sum({<Rolling period for 3 Months with the help of Month ID>}Sales)
Dim: Month	Dec	Nov	Oct	Sum(all months)/3

- Priya

Re: Rolling Period with Average

marcus_sommer — Sun, 04 Sep 2016 08:43:15 GMT

Take a look here: Calculating rolling n-period totals, averages or other aggregations

- Marcus

Re: Rolling Period with Average

antoniotiman — Sun, 04 Sep 2016 08:51:32 GMT

Hi,

see attachment.

Regards,

Antonio

Re: Rolling Period with Average

jyothish8807 — Sun, 04 Sep 2016 08:54:11 GMT

Hi Priya,

I dont think your requirement can be achieved using single pivot chart.

Try to create a pivot with rolling 3 sales and other one with Avg of rolling 3 month sales and keep it below the first one.

Keep the dimension same for both the charts.

This is a work around, will let you know if something comes in to my mind.

Regards

Re: Rolling Period with Average

priyarane — Sun, 04 Sep 2016 10:08:17 GMT

Thanks Antonio for your reply. Is it possible for rolling period.

My rolling expression for ex: sum({<Month={'>=$(=max(Month)-2)<=$(=max(Month))'}>}Amount)

Re: Rolling Period with Average

antoniotiman — Sun, 04 Sep 2016 10:50:07 GMT

Yes, instead of RangeAvg() and Sum(Value).

Divide by 3 or (dynamically)

/Count({<Month={'>=$(=max(Month)-2)<=$(=max(Month))'}>} DISTINCT Month)