Complex corporation structure

Mon, 07 Dec 2009 04:13:11 GMT

Hi everyone,

I have a very Complex corporation structure to build in qv.

This corporation is built like a big tree of companies.

Each company has a different share in the companies below it. this tree have 5-7 levels.

My problem is that i don't know how to load a field from a company on the lowest level ("amount" for example) to companies in the higher levels that have "x" share in it.

for example:

"A" company has a 20% share in "B" company and 40% in "C" company.

"D" company has a 60% share in "B" company and 80% in "E" company.

"B" company has a 70% share in "F" company and 80% in "G" company.

the field "amount" in company F = 80

the field "amount" in company G = 200

the field "amount" in company E = 100

the field "amount" in company C= 50

how can i calculate the "amount" of company "A"?

Regards,

Matan.

Complex corporation structure

prieper — Mon, 07 Dec 2009 16:41:01 GMT

Think that without having info on company "D", you cannot solve. Putting your statements together we have

B= 0.2A + 0.6D
C=0.4A
E=0.8D
F=0.7B
G=0.8B

substituting e.g. F will result in

F=0.7*(0.2A + 0.6D) = 0.14A + 0.42D -> F/0.42D/0.14 = A

If you do not know "D" you are lost.

Peter

topic Complex corporation structure in QlikView

Complex corporation structure

Complex corporation structure