topic Re: Aggregation and Moving Average in QlikView

Aggregation and Moving Average

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

Hi,

I have the following table and require an expression to calculate the 30 day moving average and the turn ratio at each date.

For example, with respect to 12 Feb 2016, the sum of the accumulated balances for the past 30 days (i.e. from 13 Jan 2016 - 12 Feb 2016) is 64,126. The average is 2,137 (64,126/30).

The turn ratio for 12 Feb 2016 would be (Opening balance +Purchases-Closing balance)/Average

=(2584+2-1815)/2137 = 0.36

Any ideas?

Thanks

Shamit

Re: Aggregation and Moving Average

Gysbert_Wassenaar — Fri, 20 May 2016 07:21:44 GMT

Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations

Re: Aggregation and Moving Average

shamitshah — Sun, 22 May 2016 04:20:00 GMT

Hi Gysbert,

The As of Table solution is perfect.

I am able to get the rolling balance and average.

Thanks

Shamit