https://community.qlik.com/t5/QlikView/Questions-about-drill-down-and-show-the-table/m-p/926836#M977686 <HTML><HEAD></HEAD><BODY><P>Hi,guys!</P><P>I have two tables as follows,they are company table and staff table.<IMG alt="TABLE.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97259_TABLE.jpg" style="height: 468px; width: 620px;" /></P><P>We have four company levels from 1 to 4 from the first table.We can distinguish the level from the companyID.We can see the staff's company from the second table of the field subordinate company.</P><P>Now,I want to realize the function about drilling down from 1 to 4 according to the company name if possible,It shows as follows if I click some second level company.How to do this?</P><P><IMG alt="1.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/97260_1.jpg" style="height: 60px; width: 620px;" /></P><P>We can see that the company name of&nbsp; CCC and DDD belong to BB from company table ,It shows CCC and DDD if I click BB&nbsp; .The table shows information about three level company .How to do this?</P><P><IMG alt="2.jpg" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/97261_2.jpg" style="max-width: 620px; height: auto;" /></P><P>Thank you for advance!</P></BODY></HTML> Fri, 28 Aug 2015 07:55:23 GMT 2015-08-28T07:55:23Z https://community.qlik.com/t5/QlikView/Questions-about-drill-down-and-show-the-table/m-p/926836#M977686 <HTML><HEAD></HEAD><BODY><P>Hi,guys!</P><P>I have two tables as follows,they are company table and staff table.<IMG alt="TABLE.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97259_TABLE.jpg" style="height: 468px; width: 620px;" /></P><P>We have four company levels from 1 to 4 from the first table.We can distinguish the level from the companyID.We can see the staff's company from the second table of the field subordinate company.</P><P>Now,I want to realize the function about drilling down from 1 to 4 according to the company name if possible,It shows as follows if I click some second level company.How to do this?</P><P><IMG alt="1.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/97260_1.jpg" style="height: 60px; width: 620px;" /></P><P>We can see that the company name of&nbsp; CCC and DDD belong to BB from company table ,It shows CCC and DDD if I click BB&nbsp; .The table shows information about three level company .How to do this?</P><P><IMG alt="2.jpg" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/97261_2.jpg" style="max-width: 620px; height: auto;" /></P><P>Thank you for advance!</P></BODY></HTML> Fri, 28 Aug 2015 07:55:23 GMT https://community.qlik.com/t5/QlikView/Questions-about-drill-down-and-show-the-table/m-p/926836#M977686 2015-08-28T07:55:23Z