topic calculation of the efficiency in QlikView https://community.qlik.com/t5/QlikView/calculation-of-the-efficiency/m-p/197988#M57444 <HTML><HEAD></HEAD><BODY><P>Looks like you neeed a weighted mean. You need to record the number of lines for each month and weight the monthly efficiency by the monthly weight. IN your case it would be</P><P>.9X +.9X +.9X .9X +.9X +.9X +.9(X+1) +.9(X+1)+.9(X+1)+.9(X+1)+.9(X+1)+.9(X+1)<BR />-----------------------------------------------------------------------------------------------------------<BR />X+X+X+X+X+X+(X+1)+(X+1)+(X+1)+(X+1)+(X+1)+(X+1)</P><P>That would be for the whole year.</P><P>See http://en.wikipedia.org/wiki/Weighted_mean for a good description of a weighted mean.</P><P>Steve</P></BODY></HTML> Mon, 13 Sep 2010 12:07:39 GMT 2010-09-13T12:07:39Z calculation of the efficiency https://community.qlik.com/t5/QlikView/calculation-of-the-efficiency/m-p/197987#M57443 <HTML><HEAD></HEAD><BODY><P>Hey everyone.<BR /><BR />It seem simple to me (at least hope)<BR /><BR />I make a calculation of the efficiency of production lines by multiplying the number of hours by lines.<BR /><BR />And everything works fine but ...<BR /><BR />When I added a new production line to the system in July, I get a funny situation.<BR /><BR />In the months before I get a 90% efficiency<BR />In the months from July receives an average of 90%.<BR /><BR />But if I choose all year (January to August) I receive 70% efficiency as the system multiplying the X +1 lines for all the year. How can I set it to multiplying by X until June and July to the end of the year will be multiplying with X +1 lines</P></BODY></HTML> Mon, 13 Sep 2010 09:18:16 GMT https://community.qlik.com/t5/QlikView/calculation-of-the-efficiency/m-p/197987#M57443 2010-09-13T09:18:16Z calculation of the efficiency https://community.qlik.com/t5/QlikView/calculation-of-the-efficiency/m-p/197988#M57444 <HTML><HEAD></HEAD><BODY><P>Looks like you neeed a weighted mean. You need to record the number of lines for each month and weight the monthly efficiency by the monthly weight. IN your case it would be</P><P>.9X +.9X +.9X .9X +.9X +.9X +.9(X+1) +.9(X+1)+.9(X+1)+.9(X+1)+.9(X+1)+.9(X+1)<BR />-----------------------------------------------------------------------------------------------------------<BR />X+X+X+X+X+X+(X+1)+(X+1)+(X+1)+(X+1)+(X+1)+(X+1)</P><P>That would be for the whole year.</P><P>See http://en.wikipedia.org/wiki/Weighted_mean for a good description of a weighted mean.</P><P>Steve</P></BODY></HTML> Mon, 13 Sep 2010 12:07:39 GMT https://community.qlik.com/t5/QlikView/calculation-of-the-efficiency/m-p/197988#M57444 2010-09-13T12:07:39Z