topic Re: Grouping & Sum by Row, Table, Straight Table. in QlikView https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382294#M808363 <HTML><HEAD></HEAD><BODY><P>Thats been busting my head, simple. Feel embarrassed now. Thank you.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Tue, 17 Oct 2017 11:37:58 GMT bnelson111 2017-10-17T11:37:58Z Grouping & Sum by Row, Table, Straight Table. https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382292#M808361 <HTML><HEAD></HEAD><BODY><P>I have a table box as per below with no calculations. </P><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="332" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 784px; height: 318px;" width="784"><TBODY><TR><TD class="xl63" height="17" width="83">Shipped Qty</TD><TD class="xl63" style="border-left: none;" width="110">Shipped Item Area</TD><TD class="xl63" style="border-left: none;" width="146">Shipped Item Code</TD><TD class="xl63" style="border-left: none;" width="54">Ship Req</TD><TD class="xl63" style="border-left: none;" width="89">Month Shipped</TD><TD class="xl63" style="border-left: none;" width="70">Sales Order</TD><TD class="xl63" style="border-left: none;" width="90">Customer Code</TD><TD class="xl63" style="border-left: none;" width="96">SoOderLine.Unit</TD><TD class="xl63" style="border-left: none;" width="64">Cust</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">3,012,904</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00982</TD><TD class="xl66" style="border-top: none; border-left: none;">50577</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230272</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">190918-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100331</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.0038</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">2,147,140</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00679</TD><TD class="xl66" style="border-top: none; border-left: none;">16383</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230155</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">193438-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100005</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00153</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">2,091,500</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00679</TD><TD class="xl66" style="border-top: none; border-left: none;">16382</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">229715</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">192088-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100005</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00153</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,972,390</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.01080</TD><TD class="xl66" style="border-top: none; border-left: none;">15253</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230235</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">188006-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100382</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00226</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,966,500</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.01779</TD><TD class="xl66" style="border-top: none; border-left: none;">50435</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230314</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">192321-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100353</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00288</TD><TD class="xl66" style="border-top: none; border-left: none;">4</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,764,851</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00945</TD><TD class="xl66" style="border-top: none; border-left: none;">13700</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230086</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">188127-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100235</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.0014</TD><TD class="xl66" style="border-top: none; border-left: none;">5</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,484,840</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00594</TD><TD class="xl66" style="border-top: none; border-left: none;">18544</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230236</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">190207-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100307</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00098</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,349,200</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00731</TD><TD class="xl66" style="border-top: none; border-left: none;">13910</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230274</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">189507-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100005</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00207</TD><TD class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,322,540</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00987</TD><TD class="xl66" style="border-top: none; border-left: none;">18743</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230449</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">192428-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100307</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00112</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,247,400</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00817</TD><TD class="xl66" style="border-top: none; border-left: none;">18332</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230233</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">191003-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100364</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00148</TD><TD class="xl66" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,194,264</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.01071</TD><TD class="xl66" style="border-top: none; border-left: none;">18844</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230449</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">192583-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100307</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.00135</TD><TD class="xl66" style="border-top: none; border-left: none;">4</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1,175,940</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.01095</TD><TD class="xl66" style="border-top: none; border-left: none;">18935</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">230366</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD class="xl66" style="border-top: none; border-left: none;">193585-1</TD><TD class="xl66" style="border-top: none; border-left: none;">100235</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0.0021</TD><TD class="xl66" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P></P><P>What I'm attempting to do is perform a calculation per row in this case sales order row. Sum is (Shipped Qty) * (Shipped item Area). If i do this in straight table using sales order as dimension with following calculation "sum(ConfirmedShippedQty)*sum([Item Table.AREALABEL])" no worries all okay but i want it by cust, problem is each line needs equation performed. Don't want to use pivot table.</P><P></P><P>Any ideas. </P><P></P><P>Thanks in advance. Brett</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382292#M808361 bnelson111 2020-11-25T16:16:04Z Re: Grouping & Sum by Row, Table, Straight Table. https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382293#M808362 <HTML><HEAD></HEAD><BODY><P>Try this may be</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum(ConfirmedShippedQty * [Item Table.AREALABEL])</STRONG></SPAN></P></BODY></HTML> Tue, 17 Oct 2017 11:32:36 GMT https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382293#M808362 sunny_talwar 2017-10-17T11:32:36Z Re: Grouping & Sum by Row, Table, Straight Table. https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382294#M808363 <HTML><HEAD></HEAD><BODY><P>Thats been busting my head, simple. Feel embarrassed now. Thank you.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Tue, 17 Oct 2017 11:37:58 GMT https://community.qlik.com/t5/QlikView/Grouping-Sum-by-Row-Table-Straight-Table/m-p/1382294#M808363 bnelson111 2017-10-17T11:37:58Z