topic Re: scripting in QlikView https://community.qlik.com/t5/QlikView/scripting/m-p/772774#M665971 <HTML><HEAD></HEAD><BODY><P>Missing group by. Try like:</P><P>Load </P><P>country,</P><P>sum(sales)</P><P>from sales.qvd <STRONG>group by country</STRONG>;</P></BODY></HTML> Thu, 04 Dec 2014 05:40:25 GMT tresB 2014-12-04T05:40:25Z scripting https://community.qlik.com/t5/QlikView/scripting/m-p/772773#M665970 <HTML><HEAD></HEAD><BODY><P>what is wrong with below script?</P><P>Load </P><P>country,</P><P>sum(sales)</P><P>from sales.qvd;</P></BODY></HTML> Thu, 04 Dec 2014 05:38:48 GMT https://community.qlik.com/t5/QlikView/scripting/m-p/772773#M665970 2014-12-04T05:38:48Z Re: scripting https://community.qlik.com/t5/QlikView/scripting/m-p/772774#M665971 <HTML><HEAD></HEAD><BODY><P>Missing group by. Try like:</P><P>Load </P><P>country,</P><P>sum(sales)</P><P>from sales.qvd <STRONG>group by country</STRONG>;</P></BODY></HTML> Thu, 04 Dec 2014 05:40:25 GMT https://community.qlik.com/t5/QlikView/scripting/m-p/772774#M665971 tresB 2014-12-04T05:40:25Z Re: scripting https://community.qlik.com/t5/QlikView/scripting/m-p/772775#M665972 <HTML><HEAD></HEAD><BODY><P>Group By is missing</P><P></P><P>Load </P><P><STRONG>country</STRONG>,</P><P>sum(sales)</P><P>from sales.qvd</P><P>Group By </P><P><STRONG>country</STRONG>;</P><P></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Thu, 04 Dec 2014 05:47:46 GMT https://community.qlik.com/t5/QlikView/scripting/m-p/772775#M665972 its_anandrjs 2014-12-04T05:47:46Z Re: scripting https://community.qlik.com/t5/QlikView/scripting/m-p/772776#M665973 <HTML><HEAD></HEAD><BODY><P>When using aggregation functions (count, sum, min, max, avg, ...) in a load (or select), you have to include ALL fields without aggregation function in the group by clause.</P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 06 Dec 2014 12:27:42 GMT https://community.qlik.com/t5/QlikView/scripting/m-p/772776#M665973 MarcoWedel 2014-12-06T12:27:42Z