Recursive hierarchy question...

[#1]

Hi Qlikview gurus out there,

I have the following hierarchy issue which is getting the better of me.

I've tried using the hierarchy function, but because it's recursive it doesn't seem to work.

Basically I have two fields, Item1 and Item2. Item2 can be both a parent and a child.

For example: 200813 is a child of 5000277. 200813 then has 2 items underneath is. -400 and 500.

This is just one example, but some Items may have many items underneath it(children), which then have items underneath them.

I have attached a sample of what I'm trying to show.

Any help would be appreciated!

[#2]

I'm on the right track. But still not quite right.

If you look at Level0, 200813 should have 2 items underneath it. ie. 500 and 400, but my example is only returning 500???

Any ideas?

[#3]

Any suggestions?

[#4]

I don't know if this is what you are looking for?

/Martin