10 Replies Latest reply: Mar 9, 2018 9:33 AM by Colin O'Donnell RSS

    moving average in a Pivot Table

    Colin O'Donnell

      Hello all,

       

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

       

      I then create a Pivot Table table as follows:

      PivotTable.png

       

      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