topic Hierarchy Tree view was empty in QlikView

Hierarchy Tree view was empty

mustafaelryah — Wed, 25 Nov 2020 16:16:04 GMT

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:

kindly find the data details view:

Waiting for your ideas to solve the empty TreeView

Re: Hierarchy Tree view was empty

Gysbert_Wassenaar — Mon, 24 Oct 2016 09:20:57 GMT

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);

Re: Hierarchy Tree view was empty

mustafaelryah — Mon, 24 Oct 2016 09:31:30 GMT

worked successfully , kindly can you explain what happened ?

Re: Hierarchy Tree view was empty

Anil_Babu_Samineni — Mon, 24 Oct 2016 09:32:47 GMT

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;