9 Replies Latest reply: Jan 6, 2012 8:17 AM by Raghavendra Suryakumar RSS

    Rolling Avg expression not working

    Raghavendra Suryakumar

      Hi All,


      We have a requirement to calculate Rolling average for monthly revenue.  I have tried to calculate the rolling average in  Qlikview with below expression


      rangeavg(Above(Sum(Revenue),0,6)) .  At the same time I have also calculated average manually to cross verify the same.  The manual calculation is not


      matching with the average being calculated by Expression.  I am attaching Qvw application and supporting excel for your reference.  Can you please suggest where I am missing.