topic Re: PROBLEM WITH HIERARCHY in QlikView

PROBLEM WITH HIERARCHY

adiarnon — Sun, 22 May 2016 14:18:04 GMT

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 — Sun, 22 May 2016 15:02:34 GMT

Please post a small qlikview document that illustrates the problem.

adiarnon — Mon, 23 May 2016 08:32:38 GMT

ATTACH

adiarnon — Mon, 23 May 2016 13:14:46 GMT

Gysbert_Wassenaar — Mon, 23 May 2016 16:31:54 GMT

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

adiarnon — Tue, 24 May 2016 06:12:38 GMT

tnx for tring to help

i will try to explain

i have my acount dimension-

MY FACT

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 +

THATS THE CALCULATION THAT I NEED

I DON KNOW HOW TO MAKE IT WORK?!

HOPE ITS CLEAR NOW

ADI

adiarnon — Wed, 25 May 2016 04:38:19 GMT