topic Re: Not able to show tree view structure in QlikView

Not able to show tree view structure

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

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.

ParentData	ChildData	Path	Org_Level
Library	Book	Book<-Library	1
Library	Notes	Notes<-Library	1
Library	Art	Art<-Book<-Library	2
Library	Science	Science<-Notes<-Library	2

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.

Please help me on this.

Thanks

Pushkar

Re: Not able to show tree view structure

oknotsen — Sun, 03 Apr 2016 12:29:44 GMT

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:

Hierarchy ‒ QlikView

Re: Not able to show tree view structure

swuehl — Sun, 03 Apr 2016 12:41:04 GMT

I believe your paths should be read left to right and root to leave, so you need to transform

Science<-Notes<-Library

Library -> Notes -> Science

Then the tree view in listbox should work (using '->' as tree view separator)

Re: Not able to show tree view structure

Sun, 03 Apr 2016 12:49:31 GMT

Hi Swuehl,

I have Path column in one of the table which has the hierarchy. So i want to show the hierarchy as tree tree structure as i described in above image.

If i select Org_Level=1 then i have 2 records in Path column for Org_Level=1 i.e.

Book<-Library and Notes<-Library. I want Library as Root node while Book and Notes should be children like below:

https://community.qlik.com/servlet/JiveServlet/showImage/2-1011316-120331/pastedImage_2.png

Please suggest what code should i write??

Re: Not able to show tree view structure

Sun, 03 Apr 2016 12:52:03 GMT

I can show the path <- or -> and can represent my data in list box as tree structure using <- or -> as separator but output is not coming as per my image.

Please help on this.

Regards

Pushpendra

Re: Not able to show tree view structure

Mon, 11 Apr 2016 07:16:35 GMT

Hi All,

I have created Org Chart with the help of Qlikview Extension object.

Thanks

Pushpendra