Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I am attaching the sample data in which two sheets are there , 1 is Hierarchy and other is Calculated Accounts .
Hierarchy sheet contains the structure that i am showing 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 shows.
Please see the screenshot also.
Maybe this is helpful: https://community.qlik.com/search.jspa?q=hierarchy&type=document
- Marcus