Unpatch to reveal tree

[mato32188]

Hi everybody,

I have a problem with "unpatching" data from 2 fields that could be in Column1 as well as in Column2. Lets get a problem.

1--------------->n

ID code     MID code

as12          tiz56

as12          u25-d

as12          ie9-9

tiz56          u25-d

ie9-9          zzz8

zzz8          15d

zzz8          16d

and so forth

....It is a mixture of ID codes, that have MID codes, but MID codes could be also in table ID code and could also have their MID codes.

Imagine: I have a product (ID code) constructed from parts (MID codes), but parts (now ID codes) could be constructed from another parts(MID codes) and those parts could be also (ID codes) like products. We cannot filter finished products out, this problem is given as I mentioned.

What we need is to create a TREE. Hierarchy function was used, but it didnt work.

Thanks guys a lot.

[Gysbert_Wassenaar]

Qlikview stores its data in tables, not trees (aka graphs). So there's no way to store a tree other then as fields in a table. Which is what the hierarchy function is for. The hierarchy function can create a path field which contains the path from the root to the node. The nodes are separated by a path delimiter. This path delimiter can be used in a listbox to show the path field as a tree. That's the only way to show a tree (well, other than using images of for example christmas trees).