topic Calculate Rolling Average When Data is missing in QlikView https://community.qlik.com/t5/QlikView/Calculate-Rolling-Average-When-Data-is-missing/m-p/458642#M171197 <HTML><HEAD></HEAD><BODY><P>Is this example I using the above function to create a rolling average of sales over a 3 week period.&nbsp; If I get a report of sales each week then everything works fine (That would be product A in the example).&nbsp; My problem is for some inputs of if they don't have any sales for a product during a week they don't report a value at all (products B,C) in the example</P><P></P><P>Is there a different function to use or what have other folks used to handle this situation.</P></BODY></HTML> Thu, 20 Dec 2012 20:58:17 GMT 2012-12-20T20:58:17Z Calculate Rolling Average When Data is missing https://community.qlik.com/t5/QlikView/Calculate-Rolling-Average-When-Data-is-missing/m-p/458642#M171197 <HTML><HEAD></HEAD><BODY><P>Is this example I using the above function to create a rolling average of sales over a 3 week period.&nbsp; If I get a report of sales each week then everything works fine (That would be product A in the example).&nbsp; My problem is for some inputs of if they don't have any sales for a product during a week they don't report a value at all (products B,C) in the example</P><P></P><P>Is there a different function to use or what have other folks used to handle this situation.</P></BODY></HTML> Thu, 20 Dec 2012 20:58:17 GMT https://community.qlik.com/t5/QlikView/Calculate-Rolling-Average-When-Data-is-missing/m-p/458642#M171197 2012-12-20T20:58:17Z