topic Re: hierarchy with weight in QlikView https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160356#M378308 <HTML><HEAD></HEAD><BODY><P>Perhaps this blog post helps: <A href="https://community.qlik.com/qlik-blogpost/4325">Bill of Materials</A></P></BODY></HTML> Wed, 18 May 2016 12:15:05 GMT Gysbert_Wassenaar 2016-05-18T12:15:05Z hierarchy with weight https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160354#M378306 <HTML><HEAD></HEAD><BODY><P>hi my hierarcy looks like-</P><P></P><TABLE border="1" class="jiveBorder" height="54" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 178px; height: 45px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>node</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>parent</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>weight</STRONG></P><P></P></TH></TR><TR><TD style="padding: 2px;">X1</TD><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>the <STRONG>weight</STRONG>-</P><P>the number i need to multiply the value in the fact if I WANT TO GET THE VALUE OF THE PARENT</P><P></P><P>if im using the hierarchy and hierarchybelongto</P><P></P><P>how can i do this logic?</P><P></P><P>tnx, adi</P></BODY></HTML> Tue, 17 May 2016 13:11:51 GMT https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160354#M378306 adiarnon 2016-05-17T13:11:51Z Re: hierarchy with weight https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160355#M378307 <HTML><HEAD></HEAD><BODY><P>?</P></BODY></HTML> Wed, 18 May 2016 12:10:33 GMT https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160355#M378307 adiarnon 2016-05-18T12:10:33Z Re: hierarchy with weight https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160356#M378308 <HTML><HEAD></HEAD><BODY><P>Perhaps this blog post helps: <A href="https://community.qlik.com/qlik-blogpost/4325">Bill of Materials</A></P></BODY></HTML> Wed, 18 May 2016 12:15:05 GMT https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160356#M378308 Gysbert_Wassenaar 2016-05-18T12:15:05Z Re: hierarchy with weight https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160357#M378309 <HTML><HEAD></HEAD><BODY><P>the account dimention (hierarcy) looks like-</P><P></P><TABLE border="1" class="jiveBorder" height="54" style="border: 1px solid #000000; border-image: none;"><THEAD><TR><TH class="header" style="padding: 2px; border: 1px solid #000000; border-image: none; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>ACCOUNT</STRONG></TH><TH class="header" style="padding: 2px; border: 1px solid #000000; border-image: none; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG><STRONG>ACCOUNT</STRONG> parent</STRONG></TH><TH class="header" style="padding: 2px; border: 1px solid #000000; border-image: none; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><P><STRONG>weight</STRONG></P></TH></TR></THEAD><TBODY><TR><TD style="padding: 2px; border: 1px solid #000000; border-image: none;">X1</TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;">X</TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;">2</TD></TR><TR><TD style="padding: 2px; border: 1px solid #000000; border-image: none;"></TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;"></TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;"></TD></TR></TBODY></TABLE><P></P><P>my fact table-</P><P></P><TABLE border="1" class="jiveBorder" height="54" style="border: 1px solid #000000; border-image: none;"><THEAD><TR><TH class="header" style="padding: 2px; border: 1px solid #000000; border-image: none; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>YEARMONTH</STRONG></TH><TH class="header" style="padding: 2px; border: 1px solid #000000; border-image: none; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG><STRONG>ACCOUNT</STRONG> parent</STRONG></TH><TH class="header" style="padding: 2px; border: 1px solid #000000; border-image: none; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><P><STRONG>AMOUNT</STRONG></P></TH></TR></THEAD><TBODY><TR><TD style="padding: 2px; border: 1px solid #000000; border-image: none;">201512</TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;">X1</TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;">10</TD></TR><TR><TD style="padding: 2px; border: 1px solid #000000; border-image: none;"></TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;"></TD><TD style="padding: 2px; border: 1px solid #000000; border-image: none;"></TD></TR></TBODY></TABLE><P></P><P>the amount of X (PARENT) should be 20 (10*2)</P><P></P><P>the <STRONG>weight</STRONG>-</P><P>the number i need to multiply the <STRONG>amount </STRONG>in the fact if I WANT TO GET THE VALUE OF THE PARENT</P><P></P><P>to built the account dimention im using the hierarchy and hierarchybelongto</P><P></P><P>how can i do this logic?</P><P></P><P>tnx, adi</P></BODY></HTML> Wed, 18 May 2016 12:33:02 GMT https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160357#M378309 adiarnon 2016-05-18T12:33:02Z Re: hierarchy with weight https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160358#M378310 <HTML><HEAD></HEAD><BODY><P>?</P></BODY></HTML> Tue, 24 May 2016 10:54:29 GMT https://community.qlik.com/t5/QlikView/hierarchy-with-weight/m-p/1160358#M378310 adiarnon 2016-05-24T10:54:29Z