Get entire hierarchical tree by selecting any member

Fri, 30 Jan 2015 07:36:32 GMT

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":

/ | \

B C D

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!

Re: Get entire hierarchical tree by selecting any member

Fri, 30 Jan 2015 09:04:16 GMT

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

Re: Get entire hierarchical tree by selecting any member

Sun, 01 Feb 2015 18:52:10 GMT

Thanks Joe!

topic Re: Get entire hierarchical tree by selecting any member in QlikView

Get entire hierarchical tree by selecting any member

Re: Get entire hierarchical tree by selecting any member

Re: Get entire hierarchical tree by selecting any member