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: 
mustafaelryah
Creator
Creator

Hierarchy Tree view was empty

dHello all,

I,m testing the tree view hierarchy with Family tree, I had excel sheet,

my columns is

name,
number,
level,
[Father number],

Gender

I made join function to get the father name  and it worked

then I create hierarchy function but shown empy

kindly find below here the code:

Person:

Hierarchy(number, [Father number], name,,Father_Name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);

inner Join (Person)

LOAD name as Father_Name,

number as [Father number]

Resident Person;

--------------

kindly check the below view of the empty tree:

Screenshot 2016-10-24 11.36.30.png

kindly find the data details view:

Screenshot 2016-10-24 11.41.32.png

Waiting for your ideas to solve the empty TreeView

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try this:

Person:

Hierarchy(number, [Father number], name,Father_Name,name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Try this:

Person:

Hierarchy(number, [Father number], name,Father_Name,name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);


talk is cheap, supply exceeds demand
mustafaelryah
Creator
Creator
Author

worked successfully , kindly can you explain what happened ?

Anil_Babu_Samineni

Delete one Comma from there

Hierarchy(number, [Father number], name,Father_Name, TreeView) Load

Person:

Hierarchy(number, [Father number], name,Father_Name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);

inner Join (Person)

LOAD name as Father_Name,

number as [Father number]

Resident Person;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)