topic group by? in QlikView https://community.qlik.com/t5/QlikView/group-by/m-p/737435#M1053647 <HTML><HEAD></HEAD><BODY><P><BR />tableA:</P><P>load</P><P>id,</P><P>sum(sales) as&nbsp; sales</P><P>from products</P><P>group by id;</P><P></P><P>here&nbsp; </P><P>id&nbsp;&nbsp; sales</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>4&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P></P><P>what it gives output?</P></BODY></HTML> Thu, 16 Oct 2014 06:39:03 GMT Anonymous 2014-10-16T06:39:03Z group by? https://community.qlik.com/t5/QlikView/group-by/m-p/737435#M1053647 <HTML><HEAD></HEAD><BODY><P><BR />tableA:</P><P>load</P><P>id,</P><P>sum(sales) as&nbsp; sales</P><P>from products</P><P>group by id;</P><P></P><P>here&nbsp; </P><P>id&nbsp;&nbsp; sales</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>4&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P></P><P>what it gives output?</P></BODY></HTML> Thu, 16 Oct 2014 06:39:03 GMT https://community.qlik.com/t5/QlikView/group-by/m-p/737435#M1053647 Anonymous 2014-10-16T06:39:03Z Re: group by? https://community.qlik.com/t5/QlikView/group-by/m-p/737436#M1053648 <HTML><HEAD></HEAD><BODY><P>Output will be same, No Change</P><P></P><P>Try with different input</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">id&nbsp;&nbsp; sales</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">4&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">will give you</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">id&nbsp;&nbsp; sales</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2&nbsp;&nbsp;&nbsp;&nbsp; 800&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // 200+600</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3&nbsp;&nbsp;&nbsp;&nbsp; 1300&nbsp;&nbsp;&nbsp;&nbsp; //300+1000</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">4&nbsp;&nbsp;&nbsp;&nbsp; 400</P></BODY></HTML> Thu, 16 Oct 2014 06:41:51 GMT https://community.qlik.com/t5/QlikView/group-by/m-p/737436#M1053648 CELAMBARASAN 2014-10-16T06:41:51Z