# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Calculation each Line of Order and Sum the total

Hello,

I need to calculate the total Boxes; the calculation is by each LineNumber (Quantity / CapacityBox)  then Sum the result for each line . I did with the next variable, but my result looks different, I insert into the table the calculation is by LineNumber, however I need to have the total calculation into variable.

/

Sum the Total for Each Line Estimated = Quantity / CapacityBox

Somebody can help me?

Thank you!

1 Solution

Accepted Solutions
MVP

## Re: Calculation each Line of Order and Sum the total

Try this

Sum(Aggr(

/

, DayDelivery, DayOrder, OrderNumber, LineNumber, ItemCode))

4 Replies
MVP

## Re: Calculation each Line of Order and Sum the total

Not sure I understand what you are looking to do? What is the black box in the image suppose to show?

New Contributor II

## Re: Calculation each Line of Order and Sum the total

For example:

Order Number: 90002419 has 4 lines 0,1,2 and 3 each line has Quantity / Capacity Box, the calculation is good into the table= Box Estimated  but in the total is not good the result  also the variable is not correct because is taking the total of quantity and total capacity. I want to Sum each line = Box Estimated column.

Goo result should be like this

 Box Estimated 0.200 0.100 0.250 0.500 Total Sum    1.050
MVP

Try this

Sum(Aggr(

/