https://community.qlik.com/t5/App-Development/Calculated-Dimension-for-HierarchyBelongsTo/m-p/1888869#M73229 <P>&nbsp;</P> <P>I have used the&nbsp;HierarchyBelongsTo function to create a table that lists each node, together with all the possible ancestors<BR /><BR />I would like to create a calculated dimension that returns the parent node fields for the selected nodes parents (Ancestor.Level=-1).&nbsp;<BR /><BR />I have managed to solve this problem in a number of ways...</P> <P>=aggr(nodistinct only(if(Ancestor.Type='$(=Only({&lt;"=Num([Ancestor.Level])"={'-1'}&gt;} Ancestor.Type))',Ancestor)),Node)<BR /><BR />However, I am struggling using the Only function when there are multiple parents - I would like to return all possible parents if that is possible.&nbsp;&nbsp;<BR /><BR />Does anyone have any ideas?</P> Thu, 03 Feb 2022 18:22:46 GMT HonestToad 2022-02-03T18:22:46Z https://community.qlik.com/t5/App-Development/Calculated-Dimension-for-HierarchyBelongsTo/m-p/1888869#M73229 <P>&nbsp;</P> <P>I have used the&nbsp;HierarchyBelongsTo function to create a table that lists each node, together with all the possible ancestors<BR /><BR />I would like to create a calculated dimension that returns the parent node fields for the selected nodes parents (Ancestor.Level=-1).&nbsp;<BR /><BR />I have managed to solve this problem in a number of ways...</P> <P>=aggr(nodistinct only(if(Ancestor.Type='$(=Only({&lt;"=Num([Ancestor.Level])"={'-1'}&gt;} Ancestor.Type))',Ancestor)),Node)<BR /><BR />However, I am struggling using the Only function when there are multiple parents - I would like to return all possible parents if that is possible.&nbsp;&nbsp;<BR /><BR />Does anyone have any ideas?</P> Thu, 03 Feb 2022 18:22:46 GMT https://community.qlik.com/t5/App-Development/Calculated-Dimension-for-HierarchyBelongsTo/m-p/1888869#M73229 HonestToad 2022-02-03T18:22:46Z