topic Hierarchy not displaying all values in QlikView

Hierarchy not displaying all values

pho3nix90 — Mon, 09 Jan 2012 11:36:14 GMT

Hi guys, I am currenlty trying to create a hierarchy, but the end result doesn't show all values, the data comes from 2 tables, please view exmple below:

RID	ParentID	Name
123		Level1
1234	123	Level2
12345	12345	Level3
123456	123456	Level4
1234567	1234567	Level5

RID	Person
123	John Doe
123	Jane Doe
123	John Doe 2
12356	John Doe 3
1234	Jane Doe 2

Now, the hierarchy's data would be populated something like this:

Level1:

John Doe (only displayes 1 person)

Level2:

Jane Doe 2

Level4:

John Doe 3

But I need it to display everything like:

Level1:

John Doe

Jane Doe

John Doe 2

Level2:

Jane Doe 2

Level4:

John Doe 3

Hierarchy not displaying all values

swuehl — Mon, 09 Jan 2012 12:49:15 GMT

If you just create two list boxes, one for Name (Level) and one for Person, and you select Level1, you are not getting 3 possible values: John Doe, Jane Doe, John Doe2 in list box Person?

Have you just linked the tables by RID or have you done something else?

How have you checked your hierarchy? In what chart object with what dimensions / expressions?

Hierarchy not displaying all values

pho3nix90 — Tue, 10 Jan 2012 06:16:54 GMT

Just by RID, yes the hierarchy display correctly, but only problem is it doesn't display everyone.

I checked it in a list box, as tree with delimiter for path '/'

Yes, if I create 2 list boxes, and select level one I do get the persons that are linked to that RID. But it's not displayed in the hierarchy itself.

Hierarchy not displaying all values

swuehl — Tue, 10 Jan 2012 14:43:16 GMT

So how do you create your tree with delimiter '/' from the tables above? Could you upload a small sample .qvw?

Hierarchy not displaying all values

pho3nix90 — Wed, 11 Jan 2012 09:12:11 GMT

Hi Swuehl,

Please find attached, I have scrambled the data because this is a clients data.

Note that I am getting all data from salesforce.