Pulling my hair out over Recursive Hierarchy issue.

[#1]

Hi,

I don't have much experience with the Hierarchy function, so was wondering if someone could give me any pointers/help.

Basically I have an Item, which is the main ID(FITEM), which is made up of other Items(CITEM), which in turn may be made up of other Items. etc etc. CITEM.

In my case I have FITEM-5002227, which is made up of Items underneath it, one being 200813.

200813 has 4 Items underneath it, 2 of those Items then have Items underneath them...so on and so forth.

Basically I'm trying to achieve this recursive structure, to show this Hierarchy in a chart table.

I've had a look at the manual, viewed other related posts and played around with the Hierarchy function, but I think I'm going around in circles.

I've attached a sample of what I'm working on.

Any help would be appreciated!

Xena

[#2]

Xena,

I hope the attached sample helps a bit.

I used Regions instead of items for (at least for me) better readability.

Best,
Thilo

[#3]

Thanks Thilo!

I'll be able to achieve what what I'm looking for using this example.

[#4]

Hi,

I'm on the right track, but not sure how to get the very Top Level to show all Item's underneath.

I've attached an example with a chart table having Item 5002227 which has Items underneath it, one being 200813

Then 200813 should have Items underneath it and some of those Items have items etc etc.....

My chart should look something like :

5002227>200813 >750330>903930 (in this case the lowest item)

>item. >item...

>item

How could I get this to show in my example .qvw?

Thanks!

[#5]

Hi,

Hope you are looking for this only

L1	L0	ParentID1	ID	Expression
5002227	200813	750330	903930	1
		750331	903930	1
-	5002227	200813	500394	1
			500395	1
			750330	1
			750331	1
	-	5002227	200813	1
			455032	1
			490881	1
			540042	1
			605185	1
			640008	1
			650003	1
			694426	1
			5002225	1

Rahul

[#6]

Thanks Rahul!

This is great.

[marcohadiyanto]

hi.. i want to ask about hierarchy,

any solution, if i wanna create hierarchy when ChildID and ParentId have the same id?