Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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
Not applicable
Author

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

Not applicable
Author

Thanks Joe!