# New to QlikView

Discussion board where members can get started with QlikView.

Contributor

## Grouping & Sum by Row, Table, Straight Table.

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

 Shipped Qty Shipped Item Area Shipped Item Code Ship Req Month Shipped Sales Order Customer Code SoOderLine.Unit Cust 3,012,904 0.00982 50577 230272 Sep 190918-1 100331 0.0038 2 2,147,140 0.00679 16383 230155 Sep 193438-1 100005 0.00153 2 2,091,500 0.00679 16382 229715 Sep 192088-1 100005 0.00153 2 1,972,390 0.01080 15253 230235 Sep 188006-1 100382 0.00226 3 1,966,500 0.01779 50435 230314 Sep 192321-1 100353 0.00288 4 1,764,851 0.00945 13700 230086 Sep 188127-1 100235 0.0014 5 1,484,840 0.00594 18544 230236 Sep 190207-1 100307 0.00098 2 1,349,200 0.00731 13910 230274 Sep 189507-1 100005 0.00207 2 1,322,540 0.00987 18743 230449 Sep 192428-1 100307 0.00112 3 1,247,400 0.00817 18332 230233 Sep 191003-1 100364 0.00148 3 1,194,264 0.01071 18844 230449 Sep 192583-1 100307 0.00135 4 1,175,940 0.01095 18935 230366 Sep 193585-1 100235 0.0021 1

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.

1 Solution

Accepted Solutions
MVP

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

Try this may be

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

2 Replies
MVP

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

Try this may be

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

Highlighted
Contributor

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

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