topic Moving Averages with multiple dimensions in QlikView https://community.qlik.com/t5/QlikView/Moving-Averages-with-multiple-dimensions/m-p/377048#M140585 <HTML><HEAD></HEAD><BODY><P>Has anyone had any luck with moving averages with multiple dimensions?&nbsp; For example, I want to see moving 7, 14, 28 day moving average (set as variable) for each of our points of sale (POS) on one line chart. So my dimensions are date and POS. I can see that my formula is working correctly when i use a straight table but when I try a line chart, it will only plot the actuals. Also, if I remove POS which then aggregates them, then the chart works perfectly. Thoughts?</P></BODY></HTML> Fri, 10 Aug 2012 19:35:32 GMT 2012-08-10T19:35:32Z Moving Averages with multiple dimensions https://community.qlik.com/t5/QlikView/Moving-Averages-with-multiple-dimensions/m-p/377048#M140585 <HTML><HEAD></HEAD><BODY><P>Has anyone had any luck with moving averages with multiple dimensions?&nbsp; For example, I want to see moving 7, 14, 28 day moving average (set as variable) for each of our points of sale (POS) on one line chart. So my dimensions are date and POS. I can see that my formula is working correctly when i use a straight table but when I try a line chart, it will only plot the actuals. Also, if I remove POS which then aggregates them, then the chart works perfectly. Thoughts?</P></BODY></HTML> Fri, 10 Aug 2012 19:35:32 GMT https://community.qlik.com/t5/QlikView/Moving-Averages-with-multiple-dimensions/m-p/377048#M140585 2012-08-10T19:35:32Z Re: Moving Averages with multiple dimensions https://community.qlik.com/t5/QlikView/Moving-Averages-with-multiple-dimensions/m-p/377049#M140586 <HTML><HEAD></HEAD><BODY><P>And your expression that is not working in charts but works in table is ?</P></BODY></HTML> Mon, 03 Sep 2012 14:30:16 GMT https://community.qlik.com/t5/QlikView/Moving-Averages-with-multiple-dimensions/m-p/377049#M140586 whiteline 2012-09-03T14:30:16Z