Help with Hierarchy ?

[#1]

Hi,

Can anyone please help me in creating tree structure  hierarchy for the below sample data i?

Test:

load * inline [

Highlevel, Parent 6, Parent 5, Parent 4, Parent 3,Parent 2,Parent 1, id

8,7,6,5,4,3,2,1

8,,,,,8,7,6

8,,,,,,,1

8,,,,,,,8

17,,,14,13,12,11,10];

Thanks in advance

[Agis-Kalogiannis]

Hi Robert

In order to create a tree structure, your data needs to be in an adjacent node format.

Example:

Table with three columns:

NodeID, ParendID, NodeName

In order to achieve something like this from your current data, you need to load it as a crosstable so as to create this adjacent load table.

Then you can use the hierarchy function to create the tree structure and even a tree list box.

I hope this helps

Regards

Agis

[#3]

HI,

Thanks for the reply. I tried what you said, but unable to get the expected results .

Can you please use my attached qvw to demonstrate it.

Thanks

[Agis-Kalogiannis · Accepted solution]

Hi again Robert

I tried using your qvw to demonstrate the example, but eventually, I had to modify your table to create something that would make more sense to me, as I wasn't sure about the meaning of your data.

Anyway, I loaded the data, transformed it into a cross table and used the hierarchy function to create a treeview.

I hope this helps

Agis

[#5]

Hi Agis,

Thanks for the solution.

Can we apply the same logic for the data in attached qvw?

I am trying to have a tree like Hierarchy list box for the given data.

Thank you