topic Weighted Average in Script not as Expression in QlikView https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165231#M37629 <HTML><HEAD></HEAD><BODY><P>Can you be a bit more specific?<BR />One idea would be to build the averages and in a second table you build the weighting criteria and then merge both tables.</P><P>Peter</P></BODY></HTML> Tue, 02 Mar 2010 23:42:58 GMT prieper 2010-03-02T23:42:58Z Weighted Average in Script not as Expression https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165230#M37628 <HTML><HEAD></HEAD><BODY><P>Has anyone been successful in calculating the weighted average at script level and not run time.</P></BODY></HTML> Tue, 02 Mar 2010 16:36:32 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165230#M37628 avastani 2010-03-02T16:36:32Z Weighted Average in Script not as Expression https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165231#M37629 <HTML><HEAD></HEAD><BODY><P>Can you be a bit more specific?<BR />One idea would be to build the averages and in a second table you build the weighting criteria and then merge both tables.</P><P>Peter</P></BODY></HTML> Tue, 02 Mar 2010 23:42:58 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165231#M37629 prieper 2010-03-02T23:42:58Z Weighted Average in Script not as Expression https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165232#M37630 <HTML><HEAD></HEAD><BODY><P>Example:</P><P style="padding-left:30px;">LOAD<BR /> SomeField<BR />,sum(Price * Weight) / sum(Weight)<BR />RESIDENT SomeTable<BR />GROUP BY SomeField<BR />;</P></BODY></HTML> Tue, 02 Mar 2010 23:58:35 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-in-Script-not-as-Expression/m-p/165232#M37630 johnw 2010-03-02T23:58:35Z