topic Re: Line Total Divided by Sub Total in QlikView

Line Total Divided by Sub Total

pkelly — Sat, 16 Nov 2024 05:07:49 GMT

Have a pivot table and want to achieve the above i.e. Take the line total and divide by the sub total - see red square.

Have tried :

=sum(rcv_CostQuantity) / SUM(ALL rcv_CostQuantity)

and also...
 =sum(rcv_CostQuantity) / SUM(TOTAL rcv_CostQuantity)

Not sure if I should be doing some form of AGGR() or using the Dimensionality() function.

As usual, any assistance greatly appreciated.

Thanks

Paul

jyothish8807 — Tue, 27 Nov 2018 11:31:34 GMT

Hi Pkelly,

Can you try this:

 =sum(rcv_CostQuantity) / SUM(TOTAL<ven_Code> rcv_CostQuantity)

sunny_talwar — Tue, 27 Nov 2018 12:20:56 GMT

I believe this is what you might be looking for

=Sum(rcv_CostQuantity)/Sum(TOTAL <pro_Rpt01Description, pro_Rpt02Description, pro_Rpt03Description, Type, Code> rcv_CostQuantity)

pkelly — Tue, 27 Nov 2018 12:26:06 GMT

Thanks, you are spot on...

jyothish8807 pointed me in the right direction.

sunny_talwar — Tue, 27 Nov 2018 12:28:26 GMT

Make sense... Glad he was able to help 🙂