Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation using sum of rows in straight table

Hi Experts,

i have the following straight table

    

Area VehicleDeliveriesOrders
Total 23371285
AberdeenCoR123029
AberdeenCoR134815
AberdeenCoR1411594
AberdeenCoR15538418
AberdeenCoR16136128
AberdeenCoR1730
AberdeenCoR18880
AberdeenCoR1914093
AberdeenCoR204127
AberdeenCoR211099432
AberdeenCoR22101
AberdeenCoR237037
AberdeenCoR241911

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 VehicleDeliveriesOrders % Delivered
Total 23371285
AberdeenCoR1230290.01
AberdeenCoR1348151.60
AberdeenCoR14115942.40
AberdeenCoR155384184.68
AberdeenCoR161361280.25
AberdeenCoR17300.02
AberdeenCoR1888029.33
AberdeenCoR19140931.59
AberdeenCoR2041270.29
AberdeenCoR21109943226.80
AberdeenCoR221010.01
AberdeenCoR2370377.00
AberdeenCoR2419110.27

Is this possible?

if so, can someone please help me with expression?

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

Please help

1 Solution

Accepted Solutions
Not applicable
Author

calculation is

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

View solution in original post

2 Replies
Not applicable
Author

calculation is

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

Anil_Babu_Samineni

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)