Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creating Childs from a table

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 =

XYZX1X2X3Y1Y2Z1Z2Z3X11X12X31X32Z31Z32Y21Y211Y212

X =

X1X2X3X11X12X31X32

Y=

Y1Y2Y21Y211Y212

Any help will be really appreciated..

Nitin

Labels (1)
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

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