topic Pulling my hair out over Recursive Hierarchy issue. in QlikView

Pulling my hair out over Recursive Hierarchy issue.

Fri, 12 Mar 2010 13:09:35 GMT

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

Pulling my hair out over Recursive Hierarchy issue.

Fri, 12 Mar 2010 13:58:26 GMT

Xena,

I hope the attached sample helps a bit.

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

Best,
Thilo

Pulling my hair out over Recursive Hierarchy issue.

Fri, 12 Mar 2010 15:00:00 GMT

Thanks Thilo!

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

Pulling my hair out over Recursive Hierarchy issue.

Sat, 13 Mar 2010 15:54:23 GMT

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!

Pulling my hair out over Recursive Hierarchy issue.

Sat, 13 Mar 2010 18:17:58 GMT

Hi,

Hope you are looking for this only

L1	L0	ParentID1	ID	Expression
5002227	200813	750330	903930	1
5002227	200813	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

Pulling my hair out over Recursive Hierarchy issue.

Sat, 13 Mar 2010 18:49:22 GMT

Thanks Rahul!

This is great.

Pulling my hair out over Recursive Hierarchy issue.

marcohadiyanto — Thu, 30 Dec 2010 07:51:30 GMT

hi.. i want to ask about hierarchy,

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