topic Hierarchy association problem in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-association-problem/m-p/401125#M701862 <HTML><HEAD></HEAD><BODY><P>I have created a QV test document using excel spreadsheets, one for Data, Target, Calendar and Client Hierarchy. The Client Hierarchy headers are; Client Name, New Client Name, Hierarchy Client, Sector, Reporting Sector and Account Manager.</P><P></P><P>The particular problem relates where there are multiple companies part of one parent company but where each firm has a different sector type.</P><P></P><P><SPAN style="text-decoration: underline;">Client Name&nbsp;&nbsp; New Client Name&nbsp;&nbsp; Hierarchy Name&nbsp;&nbsp;&nbsp; Sector&nbsp;&nbsp;&nbsp; Reporting Sector&nbsp;&nbsp;&nbsp; Account Manager</SPAN></P><P>Client1a!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1All&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prof Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAA</P><P>Client1b~&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1All&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oil&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prof Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAA</P><P></P><P>QV uses Hierachy Name as the master field. So in the Sector table the individual Client1a amount appears in both IT and Oil. This means the sum total is correct but if you add the individual sector types there sum is greater. Therefore if Client1All is selected from the Hierarchy Client table then in the Sector table the same amount appears in IT and Oil.</P><P></P><P>Can anyone help me and provide a solution? The script is attached.</P></BODY></HTML> Wed, 12 Sep 2012 14:35:03 GMT simongoodman 2012-09-12T14:35:03Z Hierarchy association problem https://community.qlik.com/t5/QlikView/Hierarchy-association-problem/m-p/401125#M701862 <HTML><HEAD></HEAD><BODY><P>I have created a QV test document using excel spreadsheets, one for Data, Target, Calendar and Client Hierarchy. The Client Hierarchy headers are; Client Name, New Client Name, Hierarchy Client, Sector, Reporting Sector and Account Manager.</P><P></P><P>The particular problem relates where there are multiple companies part of one parent company but where each firm has a different sector type.</P><P></P><P><SPAN style="text-decoration: underline;">Client Name&nbsp;&nbsp; New Client Name&nbsp;&nbsp; Hierarchy Name&nbsp;&nbsp;&nbsp; Sector&nbsp;&nbsp;&nbsp; Reporting Sector&nbsp;&nbsp;&nbsp; Account Manager</SPAN></P><P>Client1a!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1All&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prof Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAA</P><P>Client1b~&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client1All&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oil&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prof Services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAA</P><P></P><P>QV uses Hierachy Name as the master field. So in the Sector table the individual Client1a amount appears in both IT and Oil. This means the sum total is correct but if you add the individual sector types there sum is greater. Therefore if Client1All is selected from the Hierarchy Client table then in the Sector table the same amount appears in IT and Oil.</P><P></P><P>Can anyone help me and provide a solution? The script is attached.</P></BODY></HTML> Wed, 12 Sep 2012 14:35:03 GMT https://community.qlik.com/t5/QlikView/Hierarchy-association-problem/m-p/401125#M701862 simongoodman 2012-09-12T14:35:03Z