Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bnelson111
Contributor

Grouping & Sum by Row, Table, Straight Table.

I have a table box as per below with no calculations.

 

Shipped QtyShipped Item AreaShipped Item CodeShip ReqMonth ShippedSales OrderCustomer CodeSoOderLine.UnitCust
3,012,9040.0098250577230272Sep190918-11003310.00382
2,147,1400.0067916383230155Sep193438-11000050.001532
2,091,5000.0067916382229715Sep192088-11000050.001532
1,972,3900.0108015253230235Sep188006-11003820.002263
1,966,5000.0177950435230314Sep192321-11003530.002884
1,764,8510.0094513700230086Sep188127-11002350.00145
1,484,8400.0059418544230236Sep190207-11003070.000982
1,349,2000.0073113910230274Sep189507-11000050.002072
1,322,5400.0098718743230449Sep192428-11003070.001123
1,247,4000.0081718332230233Sep191003-11003640.001483
1,194,2640.0107118844230449Sep192583-11003070.001354
1,175,9400.0109518935230366Sep193585-11002350.00211

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.

Any ideas.

Thanks in advance. Brett

1 Solution

Accepted Solutions

Re: Grouping & Sum by Row, Table, Straight Table.

Try this may be

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

2 Replies

Re: Grouping & Sum by Row, Table, Straight Table.

Try this may be

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

bnelson111
Contributor

Re: Grouping & Sum by Row, Table, Straight Table.

Thats been busting my head, simple. Feel embarrassed now. Thank you.