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:



      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,