topic Re: Split sum in QlikView

Split sum

simonagheo — Wed, 25 Nov 2020 16:16:04 GMT

Any idea how can I split a sum between branches depending on some variable values?

I have an Amount table and a Map table. Amount table input:

For each branch excepting T I have to calculate the value of CA/P:

Branch A: 20/10 = 2

Branch B: 30/10 = 3

Branch A proportion: 2/5 = 0.4 %

Branch B proportion: 3/5 = 0.6 %

Depending on this proportion I will divide the amount for branch T:

For branch A: 100*0.4 = 40

For branch B: 100*0.6 = 60

So the Amount table should look like this:

How can I do this in Qlik?

Thank you!

Tue, 24 May 2016 09:03:59 GMT

check attached qvw

simonagheo — Tue, 24 May 2016 09:29:54 GMT

Thank you! But when I select Branch A, I need to see Amount: 10, 20, and 40... Branch T must be deleted, and Amt must be split to other branches.

sunny_talwar — Tue, 24 May 2016 09:53:22 GMT

Is this something you want to do in the script or front end?

simonagheo — Tue, 24 May 2016 12:39:57 GMT

It's all one to me now, but I think it's better to do it in the script...