4 Replies Latest reply: Jun 10, 2011 5:21 AM by rawdenja RSS

    12 Month Moving Average Set Analysis-Plotting onto a Graph

      Hi there,

      I'm relatively new to Qlikview and having a little trouble with a set analysis that I am working on.

      What I am trying to do is a 12 month moving average. I have look at the forums and managed to create it in a table using the following set analysis:-

      =rangeavg(after(sum(sin_Sales),0,12))

      However when trying to apply this to a chart it stops working.

      Any help is gratefully recieved.

      Thanks,

      Jack