Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Get entire hierarchical tree by selecting any member

I'm fairly new to QlikView and still struggle with set analysis. Would appreciate any help with the task.

I have hierarchical data on relations between organizations. The root is A, there are three "children" and one "grandchild":

               A

          /     |    \

         B    C      D

                         |

                         E

Currently I can only get the entire tree only if I select the root ID value  in TreeID variable (ancestors table created by HierarchyBelongsTo in the script). If If I select organization D, I'll get D and E only.

My ultimate objective is to be able after selecting any value of ID to get the entire tree, from the root to the leaves.

I tried to apply set analysis expression in a straight table as a dimension:


=only({1<TreeID={"$(=Node1)"}>} total ID)

since Node1 references to the root ID whichever ID is selected. But it doesn't work.

Thanks for any help!

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Get entire hierarchical tree by selecting any member

Hi Dmitry,

If you are trying to get all values from the ID field. Just set the dimension to the field ID, then in the expression use Sum({1}1)

that will give you all values in ID regardless of selection

hope that helps

Joe

View solution in original post

2 Replies
Highlighted
Not applicable

Re: Get entire hierarchical tree by selecting any member

Hi Dmitry,

If you are trying to get all values from the ID field. Just set the dimension to the field ID, then in the expression use Sum({1}1)

that will give you all values in ID regardless of selection

hope that helps

Joe

View solution in original post

Highlighted
Not applicable

Re: Get entire hierarchical tree by selecting any member

Thanks Joe!