topic SUMS ON SCRIPT in QlikView https://community.qlik.com/t5/QlikView/SUMS-ON-SCRIPT/m-p/189689#M52473 <HTML><HEAD></HEAD><BODY><P>You can create new summed fields in the script and use the GROUP by clause to specify at what group you want to sum. Something like:</P><P>LOAD Month, sum(Sales) as "Monthly Sales"<BR />RESIDENT Sales<BR />GROUP BY Month<BR />;</P><P>-Rob</P><P></P><P></P></BODY></HTML> Tue, 23 Mar 2010 02:02:34 GMT rwunderlich 2010-03-23T02:02:34Z SUMS ON SCRIPT https://community.qlik.com/t5/QlikView/SUMS-ON-SCRIPT/m-p/189688#M52472 <HTML><HEAD></HEAD><BODY><P>I have a question, Can i do some sum on the script instead on the Set Analysis?, example i have a pivot table chart and i need to do a lot of sum with the info in the chart, it is possible to do it on the script to let less charge on the chart???</P><P></P><P>Regards</P><P>Carlos</P></BODY></HTML> Tue, 23 Mar 2010 01:03:21 GMT https://community.qlik.com/t5/QlikView/SUMS-ON-SCRIPT/m-p/189688#M52472 2010-03-23T01:03:21Z SUMS ON SCRIPT https://community.qlik.com/t5/QlikView/SUMS-ON-SCRIPT/m-p/189689#M52473 <HTML><HEAD></HEAD><BODY><P>You can create new summed fields in the script and use the GROUP by clause to specify at what group you want to sum. Something like:</P><P>LOAD Month, sum(Sales) as "Monthly Sales"<BR />RESIDENT Sales<BR />GROUP BY Month<BR />;</P><P>-Rob</P><P></P><P></P></BODY></HTML> Tue, 23 Mar 2010 02:02:34 GMT https://community.qlik.com/t5/QlikView/SUMS-ON-SCRIPT/m-p/189689#M52473 rwunderlich 2010-03-23T02:02:34Z