topic Weighted Average by sub-dimension Straight table in QlikView https://community.qlik.com/t5/QlikView/Weighted-Average-by-sub-dimension-Straight-table/m-p/818720#M288665 <HTML><HEAD></HEAD><BODY><P>This is probably an easy solution for you guys, but I have been struggling with it past 3 hours. </P><P>I scanned the community and there are many questions on weighted average but I cant seem to figure out my issue. Hopefully it is easy.</P><P>Current weighted Average formula for EGG_AGE:</P><P>Sum(Total EGG_AGE * Aggr(Sum(EGGS_SET), EGG_AGE)) / Sum(Total Aggr(Sum(EGGS_SET),EGG_AGE))</P><P></P><P>Works perfectly if I select a LOCATION_FROM (picture 1). However in a straight table with multiple LOCATION_FROM. It is a fixed value (See picture 2.)</P><P>The weighted EGG_AGE is based on the unique combination of EGG_SET by HATCH_ID (see picture 3).</P><P></P><P>I tried adding LOCATION_FROM, or HATCH_ID in the AGGR function but none of them seemed to work correctly.</P></BODY></HTML> Wed, 12 Nov 2014 14:39:21 GMT 2014-11-12T14:39:21Z Weighted Average by sub-dimension Straight table https://community.qlik.com/t5/QlikView/Weighted-Average-by-sub-dimension-Straight-table/m-p/818720#M288665 <HTML><HEAD></HEAD><BODY><P>This is probably an easy solution for you guys, but I have been struggling with it past 3 hours. </P><P>I scanned the community and there are many questions on weighted average but I cant seem to figure out my issue. Hopefully it is easy.</P><P>Current weighted Average formula for EGG_AGE:</P><P>Sum(Total EGG_AGE * Aggr(Sum(EGGS_SET), EGG_AGE)) / Sum(Total Aggr(Sum(EGGS_SET),EGG_AGE))</P><P></P><P>Works perfectly if I select a LOCATION_FROM (picture 1). However in a straight table with multiple LOCATION_FROM. It is a fixed value (See picture 2.)</P><P>The weighted EGG_AGE is based on the unique combination of EGG_SET by HATCH_ID (see picture 3).</P><P></P><P>I tried adding LOCATION_FROM, or HATCH_ID in the AGGR function but none of them seemed to work correctly.</P></BODY></HTML> Wed, 12 Nov 2014 14:39:21 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-by-sub-dimension-Straight-table/m-p/818720#M288665 2014-11-12T14:39:21Z