topic Weighted Average calculation in same column. in QlikView https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730859#M721533 <P>Hello Everyone,</P><P>I have a data of three products containing Qty, Sale Price &amp; Value(As shown Below).</P><TABLE width="278"><TBODY><TR><TD width="96">Product Name</TD><TD width="66">Particular</TD><TD width="52">UOM</TD><TD width="64">Value</TD></TR><TR><TD>A</TD><TD>Qty</TD><TD>MT</TD><TD>100</TD></TR><TR><TD>B</TD><TD>Qty</TD><TD>MT</TD><TD>150</TD></TR><TR><TD>C</TD><TD>Qty</TD><TD>MT</TD><TD>200</TD></TR><TR><TD>A</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>800</TD></TR><TR><TD>B</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>900</TD></TR><TR><TD>C</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>600</TD></TR><TR><TD>A</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>0.80</TD></TR><TR><TD>B</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.35</TD></TR><TR><TD>C</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What i wanted to do is, i want a row generated automatically after every category of Particular column i.e. after qty, rate &amp; Value respectively. Than on the inserted row i wanted to calculate sum &amp; Weighted average, Sum for all the 3 products , Weighed average Rate for Rs/MT and sum of value. What i wanted is shown below in Red colour:</P><TABLE width="278"><TBODY><TR><TD width="96">Product Name</TD><TD width="66">Particular</TD><TD width="52">UOM</TD><TD width="64">Value</TD></TR><TR><TD>A</TD><TD>Qty</TD><TD>MT</TD><TD>100</TD></TR><TR><TD>B</TD><TD>Qty</TD><TD>MT</TD><TD>150</TD></TR><TR><TD>C</TD><TD>Qty</TD><TD>MT</TD><TD>200</TD></TR><TR><TD><FONT color="#FF0000">Total</FONT></TD><TD><FONT color="#FF0000">Qty</FONT></TD><TD><FONT color="#FF0000">MT</FONT></TD><TD><FONT color="#FF0000">450</FONT></TD></TR><TR><TD>A</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>800.00</TD></TR><TR><TD>B</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>900.00</TD></TR><TR><TD>C</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>600.00</TD></TR><TR><TD><FONT color="#FF0000">Total</FONT></TD><TD><FONT color="#FF0000">Rate</FONT></TD><TD><FONT color="#FF0000">Rs/MT</FONT></TD><TD><FONT color="#FF0000">744.44</FONT></TD></TR><TR><TD>A</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>0.80</TD></TR><TR><TD>B</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.35</TD></TR><TR><TD>C</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.20</TD></TR><TR><TD><FONT color="#FF0000">Total</FONT></TD><TD><FONT color="#FF0000">Value</FONT></TD><TD><FONT color="#FF0000">Rs/Lacs</FONT></TD><TD><FONT color="#FF0000">3.35</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help me for completing the above task.</P><P>&nbsp;</P><P>Thanks &amp; Regards,</P><P>&nbsp;</P><P>Ashish&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT Learner 2020-11-25T16:16:04Z Weighted Average calculation in same column. https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730859#M721533 <P>Hello Everyone,</P><P>I have a data of three products containing Qty, Sale Price &amp; Value(As shown Below).</P><TABLE width="278"><TBODY><TR><TD width="96">Product Name</TD><TD width="66">Particular</TD><TD width="52">UOM</TD><TD width="64">Value</TD></TR><TR><TD>A</TD><TD>Qty</TD><TD>MT</TD><TD>100</TD></TR><TR><TD>B</TD><TD>Qty</TD><TD>MT</TD><TD>150</TD></TR><TR><TD>C</TD><TD>Qty</TD><TD>MT</TD><TD>200</TD></TR><TR><TD>A</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>800</TD></TR><TR><TD>B</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>900</TD></TR><TR><TD>C</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>600</TD></TR><TR><TD>A</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>0.80</TD></TR><TR><TD>B</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.35</TD></TR><TR><TD>C</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What i wanted to do is, i want a row generated automatically after every category of Particular column i.e. after qty, rate &amp; Value respectively. Than on the inserted row i wanted to calculate sum &amp; Weighted average, Sum for all the 3 products , Weighed average Rate for Rs/MT and sum of value. What i wanted is shown below in Red colour:</P><TABLE width="278"><TBODY><TR><TD width="96">Product Name</TD><TD width="66">Particular</TD><TD width="52">UOM</TD><TD width="64">Value</TD></TR><TR><TD>A</TD><TD>Qty</TD><TD>MT</TD><TD>100</TD></TR><TR><TD>B</TD><TD>Qty</TD><TD>MT</TD><TD>150</TD></TR><TR><TD>C</TD><TD>Qty</TD><TD>MT</TD><TD>200</TD></TR><TR><TD><FONT color="#FF0000">Total</FONT></TD><TD><FONT color="#FF0000">Qty</FONT></TD><TD><FONT color="#FF0000">MT</FONT></TD><TD><FONT color="#FF0000">450</FONT></TD></TR><TR><TD>A</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>800.00</TD></TR><TR><TD>B</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>900.00</TD></TR><TR><TD>C</TD><TD>Rate</TD><TD>Rs/MT</TD><TD>600.00</TD></TR><TR><TD><FONT color="#FF0000">Total</FONT></TD><TD><FONT color="#FF0000">Rate</FONT></TD><TD><FONT color="#FF0000">Rs/MT</FONT></TD><TD><FONT color="#FF0000">744.44</FONT></TD></TR><TR><TD>A</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>0.80</TD></TR><TR><TD>B</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.35</TD></TR><TR><TD>C</TD><TD>Value</TD><TD>Rs/Lacs</TD><TD>1.20</TD></TR><TR><TD><FONT color="#FF0000">Total</FONT></TD><TD><FONT color="#FF0000">Value</FONT></TD><TD><FONT color="#FF0000">Rs/Lacs</FONT></TD><TD><FONT color="#FF0000">3.35</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help me for completing the above task.</P><P>&nbsp;</P><P>Thanks &amp; Regards,</P><P>&nbsp;</P><P>Ashish&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730859#M721533 Learner 2020-11-25T16:16:04Z Re: Weighted Average calculation in same column. https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730878#M721534 <P>Check This please</P><P>&nbsp;</P><P>Neville</P> Sun, 26 Jul 2020 16:39:11 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730878#M721534 nevilledhamsiri 2020-07-26T16:39:11Z Re: Weighted Average calculation in same column. https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730882#M721535 <P>Thank you for the reply...... But i could not open the file. Will be grateful if you can give me the formula or Script written......</P><P>&nbsp;</P><P>Thanks &amp; Regards,</P><P>&nbsp;</P><P>Ashish</P> Sun, 26 Jul 2020 17:37:27 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-calculation-in-same-column/m-p/1730882#M721535 Learner 2020-07-26T17:37:27Z