topic Rolling/Moving averages in QlikView https://community.qlik.com/t5/QlikView/Rolling-Moving-averages/m-p/142042#M21616 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have a chart which shows a years worth of figure on a daily basis. There are downward spikes on this at the weekends. Is there a way in which this can be removed somehow, possibly by a rolling/moving average or by another method?</P><P>Any help or insight into this would be much appreciated.</P><P>Regards,</P><P>bc</P></BODY></HTML> Wed, 22 Apr 2009 20:56:40 GMT 2009-04-22T20:56:40Z Rolling/Moving averages https://community.qlik.com/t5/QlikView/Rolling-Moving-averages/m-p/142042#M21616 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have a chart which shows a years worth of figure on a daily basis. There are downward spikes on this at the weekends. Is there a way in which this can be removed somehow, possibly by a rolling/moving average or by another method?</P><P>Any help or insight into this would be much appreciated.</P><P>Regards,</P><P>bc</P></BODY></HTML> Wed, 22 Apr 2009 20:56:40 GMT https://community.qlik.com/t5/QlikView/Rolling-Moving-averages/m-p/142042#M21616 2009-04-22T20:56:40Z Rolling/Moving averages https://community.qlik.com/t5/QlikView/Rolling-Moving-averages/m-p/142043#M21617 <HTML><HEAD></HEAD><BODY><P>Well in your case you probably want to exclude the weekends, because those are not representative for the analysis, right ?</P><P>What I'd try is using a claculated dimension that would return null() (and suppress it) for all the weekends:</P><P>if(Weekday(myDate)&gt;=5, null(), myDate)</P><P>Then you just check "suppress value when null()"</P><P>If you didn't want to exclude weekends, then you can build the Moving Average formula, using a combination of functions RangeAvg() and Above(), but those make the chart look funny sometimes...</P><P>good luck,</P><P>Oleg</P></BODY></HTML> Thu, 23 Apr 2009 01:00:22 GMT https://community.qlik.com/t5/QlikView/Rolling-Moving-averages/m-p/142043#M21617 Oleg_Troyansky 2009-04-23T01:00:22Z