topic How to create a rolling 3 month avg. while skipping null/zero values in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-rolling-3-month-avg-while-skipping-null-zero/m-p/247786#M1206378 <HTML><HEAD></HEAD><BODY><P></P><P>I need to create a rolling 3 month average that skips over a null value.</P><P>For example:</P><P>Company 1 has data for Jan, March, and April but a zero value for Feb. I need the rolling avg. for April to include April,March, and Jan skipping over Feb.</P><P>The chart expression I am using now includes the zero Feb. value.</P><P>=rangeavg(before(SUM(Ext Rebate)/SUM(Ext Unit Price),0,3))</P><P>Thanks !</P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 19 Mar 2010 15:05:29 GMT 2010-03-19T15:05:29Z How to create a rolling 3 month avg. while skipping null/zero values https://community.qlik.com/t5/QlikView/How-to-create-a-rolling-3-month-avg-while-skipping-null-zero/m-p/247786#M1206378 <HTML><HEAD></HEAD><BODY><P></P><P>I need to create a rolling 3 month average that skips over a null value.</P><P>For example:</P><P>Company 1 has data for Jan, March, and April but a zero value for Feb. I need the rolling avg. for April to include April,March, and Jan skipping over Feb.</P><P>The chart expression I am using now includes the zero Feb. value.</P><P>=rangeavg(before(SUM(Ext Rebate)/SUM(Ext Unit Price),0,3))</P><P>Thanks !</P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 19 Mar 2010 15:05:29 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-rolling-3-month-avg-while-skipping-null-zero/m-p/247786#M1206378 2010-03-19T15:05:29Z