topic Sum order lines amount by order in QlikView https://community.qlik.com/t5/QlikView/Sum-order-lines-amount-by-order/m-p/90446#M602224 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a file containing the following info</P><P>OrderID</P><P>OderLineDescription</P><P>OrderLineAmount</P><P></P><P>I would need to create an additional column in the script that aggregates the sum of all OrderLineAmount per Order ID to get the <STRONG style="font-size: 13.3333px;">TotalOrderAmount</STRONG></P><P></P><P style="font-size: 13.3333px;">OrderID</P><P style="font-size: 13.3333px;">OderLineDescription</P><P style="font-size: 13.3333px;">OrderLineAmount</P><P style="font-size: 13.3333px;"><STRONG>TotalOrderAmount</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;">Could you please advise on the syntax?</P><P style="font-size: 13.3333px;">sum(aggr(OrderLineAmount, OrderID)) as <STRONG style="font-size: 13.3333px;">TotalOrderAmount</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;">Many thanks!<STRONG style="font-size: 13.3333px;"><BR /></STRONG></P></BODY></HTML> Thu, 20 Sep 2018 10:33:31 GMT agaetisproject 2018-09-20T10:33:31Z Sum order lines amount by order https://community.qlik.com/t5/QlikView/Sum-order-lines-amount-by-order/m-p/90446#M602224 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a file containing the following info</P><P>OrderID</P><P>OderLineDescription</P><P>OrderLineAmount</P><P></P><P>I would need to create an additional column in the script that aggregates the sum of all OrderLineAmount per Order ID to get the <STRONG style="font-size: 13.3333px;">TotalOrderAmount</STRONG></P><P></P><P style="font-size: 13.3333px;">OrderID</P><P style="font-size: 13.3333px;">OderLineDescription</P><P style="font-size: 13.3333px;">OrderLineAmount</P><P style="font-size: 13.3333px;"><STRONG>TotalOrderAmount</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;">Could you please advise on the syntax?</P><P style="font-size: 13.3333px;">sum(aggr(OrderLineAmount, OrderID)) as <STRONG style="font-size: 13.3333px;">TotalOrderAmount</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;">Many thanks!<STRONG style="font-size: 13.3333px;"><BR /></STRONG></P></BODY></HTML> Thu, 20 Sep 2018 10:33:31 GMT https://community.qlik.com/t5/QlikView/Sum-order-lines-amount-by-order/m-p/90446#M602224 agaetisproject 2018-09-20T10:33:31Z