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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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

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