topic Re: Avg sum in double Keys in load script in QlikView https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870889#M654624 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>Id,</P><P>avg(Sum) as Sum</P><P>FROM...</P><P>Group By Id;</P></BODY></HTML> Mon, 22 Jun 2015 10:50:40 GMT Anonymous 2015-06-22T10:50:40Z Avg sum in double Keys in load script https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870888#M654623 <HTML><HEAD></HEAD><BODY><P>Dear <SPAN lang="en">colleagues, good day!</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">In load script i load table from excel with two fields:</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>Id,</STRONG></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>Sum</STRONG></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">What i need: if field <STRONG>Id</STRONG> has only one <STRONG>Sum</STRONG> - in this case to save the same value</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if field <STRONG>Id</STRONG> has more than one <STRONG>Sum</STRONG> - calculate avg Sum.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">There are model and source file in attachment.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Best regards, Andrey</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks.<BR /></SPAN></P></BODY></HTML> Mon, 22 Jun 2015 10:33:19 GMT https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870888#M654623 Anonymous 2015-06-22T10:33:19Z Re: Avg sum in double Keys in load script https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870889#M654624 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>Id,</P><P>avg(Sum) as Sum</P><P>FROM...</P><P>Group By Id;</P></BODY></HTML> Mon, 22 Jun 2015 10:50:40 GMT https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870889#M654624 Anonymous 2015-06-22T10:50:40Z Re: Avg sum in double Keys in load script https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870890#M654625 <HTML><HEAD></HEAD><BODY><P>Many thanks.</P></BODY></HTML> Mon, 22 Jun 2015 10:53:55 GMT https://community.qlik.com/t5/QlikView/Avg-sum-in-double-Keys-in-load-script/m-p/870890#M654625 Anonymous 2015-06-22T10:53:55Z