Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
Any suggestions?
I don't know if this is what you are looking for?
/Martin