Unpatch to reveal tree

mato32188 — Wed, 04 Dec 2013 17:53:26 GMT

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.

Re: Unpatch to reveal tree

Gysbert_Wassenaar — Wed, 04 Dec 2013 18:01:35 GMT

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).

topic Re: Unpatch to reveal tree in QlikView

Unpatch to reveal tree

Re: Unpatch to reveal tree