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.

       

      Regards,

      Raghav