topic Re: Weighted average in QlikView https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145236#M914730 <HTML><HEAD></HEAD><BODY><P>Thank you for your help !</P></BODY></HTML> Wed, 25 May 2016 13:32:22 GMT Anonymous 2016-05-25T13:32:22Z Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145233#M914727 <HTML><HEAD></HEAD><BODY><P>Hey Guys</P><P>I need to create Weighted Average for each country e.g</P><P></P><P>Columbia :&nbsp; every row to multiply (H qty* H sul)/Sum(Total(H qty)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125757_Capture.JPG" style="height: 171px; width: 620px;" /></P><P></P><P>At the end this result is good but when i cancel the selection on Country Name the number is change i need to do aggr ? </P><P><IMG alt="Capture.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/125758_Capture.JPG" style="font-size: 13.3333px;" /></P><P>need your help please see my app.</P><P>David</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145233#M914727 Anonymous 2020-11-25T16:16:04Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145234#M914728 <HTML><HEAD></HEAD><BODY><P>Yes, you need to Aggr according the dimensions you need to weight</P></BODY></HTML> Wed, 25 May 2016 13:30:11 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145234#M914728 alexandros17 2016-05-25T13:30:11Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145235#M914729 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum(HADERA_SUL_VALUE*HADERA_QTY)/Sum(TOTAL <SPAN style="color: #ff0000;">&lt;COUNTRY_NAME&gt;</SPAN> HADERA_QTY)</STRONG></P></BODY></HTML> Wed, 25 May 2016 13:30:43 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145235#M914729 sunny_talwar 2016-05-25T13:30:43Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145236#M914730 <HTML><HEAD></HEAD><BODY><P>Thank you for your help !</P></BODY></HTML> Wed, 25 May 2016 13:32:22 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/1145236#M914730 Anonymous 2016-05-25T13:32:22Z