My data is stored in SQL Server tables and I have created dimensions and fact tables perfectly.
ParentData, ChildData, Path and Org_Level are the dimensions and I can create a qlikview report in below format.
Now I want to make a tree based on Path dimension. If I select Org_Level=1 or ParentData=Library then tree should have root node=Library and both children(Book and Notes) must be below Library joining by a line like below structure :
And If I select Org_Level 2 then my Path must show 2 more children(Art and Science) below Book and Notes.
I am able to show the Path in Tablebox and can create a tree by setting the show as tree view(separated by <-) but now in above form.
I am not sure if I understand your question correctly, but it looks like you got a table referring to itself in a node-parentnode construction. To handle that structure, look into using the Hierarchy function: