topic Re: Personal Info with Hierarchy Table in QlikView https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976779#M333823 <HTML><HEAD></HEAD><BODY><P>Hi Rendi,</P><P></P><P>I'm sorry but I can't understand your question either, can you please elaborate better?</P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Wed, 11 Nov 2015 15:33:34 GMT miguelbraga 2015-11-11T15:33:34Z Personal Info with Hierarchy Table https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976777#M333821 <HTML><HEAD></HEAD><BODY><P>Dear Qlik Developer,</P><P></P><P>I have a question for personal info with a hierarchy table.</P><P></P><P>So i have Transaction, Sales, Personal table</P><P></P><P>Transaction Table Desc :</P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 159px; height: 67px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SalesID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TransID</STRONG></TH></TR><TR><TD style="padding: 2px;">21</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">32</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">41</TD><TD style="padding: 2px;">3</TD></TR></TBODY></TABLE><P></P><P>Sales Table Desc :</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD class="xl63" height="20" width="64"><STRONG>ManagerID</STRONG></TD><TD class="xl63" style="border-left: none;" width="64"><STRONG>SupervisorID</STRONG></TD><TD class="xl63" style="border-left: none;" width="64"><STRONG>SalesID</STRONG></TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">11</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">71</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">72</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">21</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">81</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">2</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">22</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">82</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">31</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">91</TD></TR></TBODY></TABLE><P></P><P>Personal Table Desc :</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid rgb(0, 0, 0); width: 177px; height: 111px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EmpID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">One</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Two</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">Three</TD></TR><TR><TD style="padding: 2px;">11</TD><TD style="padding: 2px;">Oneone</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">Onetwo</TD></TR><TR><TD style="padding: 2px;">21</TD><TD style="padding: 2px;">Twoone</TD></TR><TR><TD style="padding: 2px;">22</TD><TD style="padding: 2px;">Twotwo</TD></TR><TR><TD style="padding: 2px;">31</TD><TD style="padding: 2px;">Threeone</TD></TR><TR><TD style="padding: 2px;">71</TD><TD style="padding: 2px;">Sevenone</TD></TR><TR><TD style="padding: 2px;">72</TD><TD style="padding: 2px;">Seventwo</TD></TR><TR><TD style="padding: 2px;">81</TD><TD style="padding: 2px;">Eightone</TD></TR><TR><TD style="padding: 2px;">82</TD><TD style="padding: 2px;">Eighttwo</TD></TR><TR><TD style="padding: 2px;">91</TD><TD style="padding: 2px;">Nineone</TD></TR></TBODY></TABLE><P></P><P></P><P style="font-size: 13.3333px;">Transaction related to Sales based on SalesID.</P><P style="font-size: 13.3333px;">But in Sales table, i have nested column (Manager -&gt; Supervisor -&gt; Sales).</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">So my question is, is it possible to make a relationship between Personal table to Sales table?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks,</P><P style="font-size: 13.3333px;">Best Regards</P></BODY></HTML> Wed, 11 Nov 2015 11:11:56 GMT https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976777#M333821 rendiyan 2015-11-11T11:11:56Z Re: Personal Info with Hierarchy Table https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976778#M333822 <HTML><HEAD></HEAD><BODY><P>I think you forgot to ask the question. What is your question?</P></BODY></HTML> Wed, 11 Nov 2015 12:58:10 GMT https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976778#M333822 Gysbert_Wassenaar 2015-11-11T12:58:10Z Re: Personal Info with Hierarchy Table https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976779#M333823 <HTML><HEAD></HEAD><BODY><P>Hi Rendi,</P><P></P><P>I'm sorry but I can't understand your question either, can you please elaborate better?</P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Wed, 11 Nov 2015 15:33:34 GMT https://community.qlik.com/t5/QlikView/Personal-Info-with-Hierarchy-Table/m-p/976779#M333823 miguelbraga 2015-11-11T15:33:34Z