15 Replies Latest reply: Feb 1, 2017 10:07 PM by Sunny Talwar RSS

    Average and Average rolling

    Khabat Stravan

      Thank you inadvance for the help with the following, I have tried to find answers to my questions here and on the web but have not succeeded with everything.

       

      I want to create charts/tables in QlikView (version 11) with the following and I need the formulas for those:

       

      1- "Three-year average for the previous 12 months rolling": ie the average of the past three rolling 12 months.

       

      Tex 201201 should be = (0(200901) +355(201001) +264(201101)) / 3, see the attached Excel file.

       

       

      2- "The average of the last three years": ie the average number of persons per month for the last three years. e.g. 201202 should be = (15(200902) +8(201002) +25 (201102)) / 3, see the attached Excel file.