# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Not applicable

## Calculation using sum of rows in straight table

Hi Experts,

i have the following straight table

 Area Vehicle Deliveries Orders Total 2337 1285 Aberdeen CoR12 30 29 Aberdeen CoR13 48 15 Aberdeen CoR14 115 94 Aberdeen CoR15 538 418 Aberdeen CoR16 136 128 Aberdeen CoR17 3 0 Aberdeen CoR18 88 0 Aberdeen CoR19 140 93 Aberdeen CoR20 41 27 Aberdeen CoR21 1099 432 Aberdeen CoR22 10 1 Aberdeen CoR23 70 37 Aberdeen CoR24 19 11

For each area, i have Deliveries and orders rexpectively. i have to calculate another column which gives % delivered

the formula for that is [Deliveries value of each vehicle] divided by the total value 2337. this total is not the expression total. it is the sum of all rows.

For eg. my first column calculation is 30/2337 = 1.28%

calculation for deliveries is sum(order_delivered)

required output:

 Area Vehicle Deliveries Orders % Delivered Total 2337 1285 Aberdeen CoR12 30 29 0.01 Aberdeen CoR13 48 15 1.60 Aberdeen CoR14 115 94 2.40 Aberdeen CoR15 538 418 4.68 Aberdeen CoR16 136 128 0.25 Aberdeen CoR17 3 0 0.02 Aberdeen CoR18 88 0 29.33 Aberdeen CoR19 140 93 1.59 Aberdeen CoR20 41 27 0.29 Aberdeen CoR21 1099 432 26.80 Aberdeen CoR22 10 1 0.01 Aberdeen CoR23 70 37 7.00 Aberdeen CoR24 19 11 0.27

Is this possible?

i tried using Total & All function, but it is not giving the sum of rows value. it is giving expression total of that column.

1 Solution

Accepted Solutions
Not applicable
Author

calculation is

sum(TOTAL Aggr(sum(order_delivered),Area, Vehicle))

2 Replies
Not applicable
Author

calculation is

sum(TOTAL Aggr(sum(order_delivered),Area, Vehicle))

Try like this for % Delivered

sum(order_delivered)/sum(total orders)

And then give relative

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)