topic Re: SPC control chart in QlikView https://community.qlik.com/t5/QlikView/SPC-control-chart/m-p/623603#M545855 <HTML><HEAD></HEAD><BODY><P>I think you can do that using the Accumulation option on the expressions tab for a straight table, </P></BODY></HTML> Tue, 11 Mar 2014 12:05:32 GMT 2014-03-11T12:05:32Z SPC control chart https://community.qlik.com/t5/QlikView/SPC-control-chart/m-p/623602#M545854 <HTML><HEAD></HEAD><BODY><P>I am trying to create an SPC control chart with moving averages. Unfortunately I don't seem to be able to calculate the first values correctly. I need the chart to do the following with the data column:</P><P></P><P>Iterate down the data</P><P>for each data point do the following:</P><UL><LI>Calculate the mean and standard deviation for all the data points so far</LI><LI>Calculate the number of data points that are above the mean+stdev</LI><LI>Calculate the number of data points that are below the mean-stdev</LI><LI>If either number of data points is 8 set the first mean value as the most recently calculated mean, stdev as most recently calculated stdev. Rinse, repeat all the way along the data set.</LI></UL><P></P><P>As far as I can see, Qlikview can't do this, however solutions involving doing this with the data during load seem to massively diminish the usefulness of Qlikview because either the data set gets huge or a limited number of user selections are available. </P></BODY></HTML> Tue, 11 Mar 2014 11:31:22 GMT https://community.qlik.com/t5/QlikView/SPC-control-chart/m-p/623602#M545854 2014-03-11T11:31:22Z Re: SPC control chart https://community.qlik.com/t5/QlikView/SPC-control-chart/m-p/623603#M545855 <HTML><HEAD></HEAD><BODY><P>I think you can do that using the Accumulation option on the expressions tab for a straight table, </P></BODY></HTML> Tue, 11 Mar 2014 12:05:32 GMT https://community.qlik.com/t5/QlikView/SPC-control-chart/m-p/623603#M545855 2014-03-11T12:05:32Z