topic Re: how to sum by group? in QlikView https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876044#M658101 <HTML><HEAD></HEAD><BODY><P>Jack,</P><P></P><P>Try this:</P><P></P><P>max(aggr(sum(quantity),group))</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Mon, 18 May 2015 04:15:59 GMT amit_saini 2015-05-18T04:15:59Z how to sum by group? https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876042#M658099 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">Hi guys,</SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">I met one problem, how to obtain each group's sum, and to save this sum as one field in script.</SPAN></P><P></P><P>The scenario is I need to monitor each group's quantity, once it exceeds one value(like 2 as below), the system will send alert.</P><P></P><P>Thank you very much!</P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 196px; height: 107px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">quantity</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">3</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 18 May 2015 03:38:54 GMT https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876042#M658099 2015-05-18T03:38:54Z Re: how to sum by group? https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876043#M658100 <HTML><HEAD></HEAD><BODY><P><BR />load&nbsp; group,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum(quantity)</P><P>from tablename</P><P>group by group;</P></BODY></HTML> Mon, 18 May 2015 04:05:25 GMT https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876043#M658100 Anonymous 2015-05-18T04:05:25Z Re: how to sum by group? https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876044#M658101 <HTML><HEAD></HEAD><BODY><P>Jack,</P><P></P><P>Try this:</P><P></P><P>max(aggr(sum(quantity),group))</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Mon, 18 May 2015 04:15:59 GMT https://community.qlik.com/t5/QlikView/how-to-sum-by-group/m-p/876044#M658101 amit_saini 2015-05-18T04:15:59Z