Help me to find Find 3 months and 6 months rolling average

[kpradeep5610]

Hey Folks,

I have a requirment in which i have to show 3 Months rolling Average in a pivot and  Bar chart.

Logic: For each month, average should be of previous 3 months including that month.

Example: If Month is Jan -2019, then average against Jan in Bar chart should be of  

                     Nov- 2018, Dec- 2018 and Jan-2019.

Likewise it should be happen for every month in the Pivot / Bar Chart in dimension.

Here is the formula which I am providing for 3 months rolling average: for Jan- 2019

((39+34+77)/(122000+764000+765000))*1000000.

 for jan- 2019 is

 Faults is ( Nov- 2018, Dec- 2018 and Jan-2019)

Qty is     ( Nov- 2018, Dec- 2018 and Jan-2019)

which is(( summation of 3 months Faults) /( summation of 3 months Qty)) * 1000000  

Like wise we have to calculate for all months

Here i'm attached one execel  file please go through this

And I requesting you all, please provide me the set expression for above requirement 

All the Best.

[Gysbert_Wassenaar]

Have a look at this document: https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...

And at this blog post: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130