topic Re: Creating Childs from a table in QlikView

Creating Childs from a table

Anonymous — Fri, 21 Nov 2014 04:44:14 GMT

Hello All,

I have a very urgent requirement..

I have attached excel for example .

Here I have the Parent Child Relation.

Now what the output is required, Suppose I select Part "A" then It will show all the other parts as child.

If "X" is selected then all is succesing parts will as child.

which means

A =

X11

X12

X31

X32

Z31

Z32

Y21

Y211

Y212

X =

X11

X12

X31

X32

Y21

Y211

Y212

Any help will be really appreciated..

Nitin

Re: Creating Childs from a table

jonathandienst — Fri, 21 Nov 2014 05:08:45 GMT

This is an n-level hierarchy with parent child relationships. Check out the Hierarchy keyword in the manual and Henric Cronstom's blog post on this topic:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/11/unbalanced-n-level-hierarchies

HTH

Jonathan

Re: Creating Childs from a table

Anonymous — Fri, 21 Nov 2014 06:02:35 GMT

Hi Jonanthan,

Thanks for your help.

If possible can you please provide an example qvw with my examle.

As I am not able to figure out with my req...