moving average in a Pivot Table

[colinodonnel]

Hello all,

I have two separate tables that I load into Qlik Sense.

I then create a Pivot Table table as follows:

Dim1 is from Table1

Dim2 is from Table 2

Average is Count of Dim1/Count of Dim2

How do I:

1 - create a 3 month moving average based on the Average Values shown.

2 - can this then be put into a chart

Thank you,

Colin

[colinodonnel]

For the chart, I just swapped "before" for "above" and this worked perfectly.

Thanks for your helps.

Solved.