PROBLEM WITH HIERARCHY

[adiarnon]

i have a hierarchy with weight field-

the account dimention (hierarcy) looks like-

ACCOUNT	ACCOUNT parent	weight
X1	X	2

my fact table-

YEARMONTH	ACCOUNT parent	AMOUNT
201512	X1	10

the amount of X (PARENT) should be 20 (10*2)

the weight-

the number i need to multiply the amount in the fact if I WANT TO GET THE VALUE OF THE PARENT

to built the account dimention im using the hierarchy and hierarchybelongto

how can i do this logic?

tnx, adi

[Gysbert_Wassenaar]

Please post a small qlikview document that illustrates the problem.

[adiarnon]

ATTACH

[adiarnon]

?

[Gysbert_Wassenaar]

Can you tell me how that document illustrates what you want? An example table with the result values you expect would help.

[adiarnon]

tnx for tring to help

i will try to explain

i have my acount dimension-

ELEMENT	PARENT	WEIGHT
A		1
B	A	-1
C	A	1
D	C	1
E	C	-1

MY FACT

ACOUNT	VALUE
B	3
C	2
D	5
E	6

WHEN I NEED THE VALUE FOR C-(D AND E HIS SONS)

SUM(VALUE (E))* WEIGHT (OF THE CONNECTION BETWEEN E+C)+

SUM(VALUE (D))* WEIGHT (OF THE CONNECTION BETWEEN D+C)+

SUM(VALUE (C))

=

6*(-1)+

5*1 +

2

=1

THATS THE CALCULATION THAT I NEED

I DON KNOW HOW TO MAKE IT WORK?!

HOPE ITS CLEAR NOW

ADI

[adiarnon]