QlikView App Dev

[#1]

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!

[#2 · Accepted solution]

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

[#3]

Thanks Joe!