topic Recursive hierarchy question... in QlikView

Recursive hierarchy question...

Thu, 30 Sep 2010 16:23:26 GMT

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!

Thu, 30 Sep 2010 18:23:31 GMT

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?

Mon, 04 Oct 2010 12:50:46 GMT

Any suggestions?

Tue, 05 Oct 2010 15:15:36 GMT

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

/Martin