Calculation using sum of rows in straight table

Wed, 25 Nov 2020 16:16:04 GMT

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?

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

Re: Calculation using sum of rows in straight table

Tue, 08 Nov 2016 16:50:28 GMT

calculation is

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

Re: Calculation using sum of rows in straight table

Anil_Babu_Samineni — Tue, 08 Nov 2016 16:51:12 GMT

Try like this for % Delivered

sum(order_delivered)/sum(total orders)

And then give relative

topic Re: Calculation using sum of rows in straight table in QlikView

Calculation using sum of rows in straight table

Re: Calculation using sum of rows in straight table

Re: Calculation using sum of rows in straight table