topic Re: Need help in QlikView https://community.qlik.com/t5/QlikView/Need-help/m-p/839646#M295103 <HTML><HEAD></HEAD><BODY><P>Maybe this is helpful: <A href="https://community.qlik.com/t5/forums/searchpage/tab/message?q=hierarchy&amp;type=document">https://community.qlik.com/search.jspa?q=hierarchy&amp;type=document</A></P><P></P><P>- Marcus</P></BODY></HTML> Sun, 24 May 2015 12:51:53 GMT marcus_sommer 2015-05-24T12:51:53Z Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/839645#M295102 <HTML><HEAD></HEAD><BODY><P>Hi All , </P><P></P><P>I am attaching the sample data in which two sheets are there , 1 is Hierarchy and other is Calculated Accounts .</P><P></P><P>Hierarchy sheet contains the structure that i am showing&nbsp; in pivot table. In this sheet all the accounts has some base accounts also .But these base accounts are present in the Calculated Account sheet (There may be possibility that in Hirerachy sheet some accounts are base acount. ) . So i need that if i select any of the account from hirarchy sheet (either from Parent or child1 or child2 or child3 or child4), its coresponding Base account&nbsp; shows.</P><P></P><P>Please see the screenshot also.</P><P></P><P><IMG alt="Capture1245.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87410_Capture1245.JPG" style="height: 319px; width: 620px;" /></P></BODY></HTML> Sun, 24 May 2015 11:37:14 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/839645#M295102 agni_gold 2015-05-24T11:37:14Z Re: Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/839646#M295103 <HTML><HEAD></HEAD><BODY><P>Maybe this is helpful: <A href="https://community.qlik.com/t5/forums/searchpage/tab/message?q=hierarchy&amp;type=document">https://community.qlik.com/search.jspa?q=hierarchy&amp;type=document</A></P><P></P><P>- Marcus</P></BODY></HTML> Sun, 24 May 2015 12:51:53 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/839646#M295103 marcus_sommer 2015-05-24T12:51:53Z