topic Re: Weighted average in QlikView https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500449#M1125380 <HTML><HEAD></HEAD><BODY><P>So the .qvw that I posted above gives you what you need?</P></BODY></HTML> Mon, 13 Jan 2014 19:20:07 GMT Nicole-Smith 2014-01-13T19:20:07Z Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500446#M1125376 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I would like to get the weighted average age of 5 persons. I get along until sum(aggr(sum(PersonWeight),Age)).</P><P>The last step of the calculation would be simply to divide this result by the total number of weighted Persons - but I dont get the right Aggr with this.</P><P></P><P>Please find attached my qvw which also includes a screenshot with my calculation in Excel.</P><P></P><P>Any ideas?</P><P></P><P>Thanks a lot in advance.</P><P>Daniel</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/51381_Capture.PNG.png" /></P></BODY></HTML> Mon, 13 Jan 2014 10:23:14 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500446#M1125376 danieloberbilli 2014-01-13T10:23:14Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500447#M1125377 <HTML><HEAD></HEAD><BODY><P>Is the attached what you're looking for?</P></BODY></HTML> Mon, 13 Jan 2014 15:07:41 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500447#M1125377 Nicole-Smith 2014-01-13T15:07:41Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500448#M1125378 <HTML><HEAD></HEAD><BODY><P>Yes, the yellow marked value of 18.79 as average year is what I am looking to get in QV</P></BODY></HTML> Mon, 13 Jan 2014 19:12:34 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500448#M1125378 danieloberbilli 2014-01-13T19:12:34Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500449#M1125380 <HTML><HEAD></HEAD><BODY><P>So the .qvw that I posted above gives you what you need?</P></BODY></HTML> Mon, 13 Jan 2014 19:20:07 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500449#M1125380 Nicole-Smith 2014-01-13T19:20:07Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500450#M1125382 <HTML><HEAD></HEAD><BODY><P>Ahhh - sorry - I didnt see your attachment - I thought you are talking about my mine <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Thanks a lot - exactly what I needed!</P><P></P><P>All the best</P><P>Daniel</P></BODY></HTML> Mon, 13 Jan 2014 19:35:32 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500450#M1125382 danieloberbilli 2014-01-13T19:35:32Z Re: Weighted average https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500451#M1125384 <HTML><HEAD></HEAD><BODY><P>Thank you that was very very helpful</P></BODY></HTML> Wed, 19 Nov 2014 20:43:35 GMT https://community.qlik.com/t5/QlikView/Weighted-average/m-p/500451#M1125384 Anonymous 2014-11-19T20:43:35Z