hierarchy list and child list

KubotaNatsuki
Frequent Contributor

hierarchy list and child list

hi!

When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy.

What i should do?

Please help me.

 

1 ACCEPTED SOLUTION

Accepted Solutions
vinayvm
Certified Master Anaplanner

Re: hierarchy list and child list

Hi @KubotaNatsuki ,

 

In your query, assuming 'Check' = assigning  to a list item in parent list, you can Lookup the parent property (which @ChrisAHeathcote explained) to apply it to child items pertaining to that parent.

 

Regards,

vinayvm

View solution in original post

8 REPLIES 8
LipChean_Soh
Certified Master Anaplanner

Re: hierarchy list and child list

Hi @KubotaNatsuki 

 

You'll need to provide more information.

I find that a working sample on Excel that you attach here normally helps.

 

Thanks,

LipChean

ChrisAHeathcote
Community Boss

Re: hierarchy list and child list

@KubotaNatsuki 

Create a module dimensioned by the child list. 

Add a list formatted line item containing the parent list.

Use; ITEM(PARENT('Child List')) to pull through the parent of the list item.

Now you can see the parent of each child list item in a single location. If a child list item does not have a parent then the result will be blank.

Chris
HeathcoteAndHerran.com
Misbah
Moderator

Re: hierarchy list and child list

@ChrisAHeathcote 

 

Shouldn't it be PARENT(ITEM(Child List))?

 

Misbah

ChrisAHeathcote
Community Boss

Re: hierarchy list and child list

ha!

Yes you are right.

 

Chris
HeathcoteAndHerran.com
KubotaNatsuki
Frequent Contributor

Re: hierarchy list and child list

Thanks for your reply!

I can do it to use 'Lookup' and 'Parent' function!
Thank you so much!

vinayvm
Certified Master Anaplanner

Re: hierarchy list and child list

Hi @KubotaNatsuki ,

 

In your query, assuming 'Check' = assigning  to a list item in parent list, you can Lookup the parent property (which @ChrisAHeathcote explained) to apply it to child items pertaining to that parent.

 

Regards,

vinayvm

KubotaNatsuki
Frequent Contributor

Re: hierarchy list and child list

Thank you for your reply!

I got it to use Lookup!! 
Thank you!!

ChrisAHeathcote
Community Boss

Re: hierarchy list and child list

@KubotaNatsuki 

While using LOOKUP will return the parent list item as per a mapping module dimensioned by the child item but the formula will not be as efficient as using PARENT. 

 

Chris
HeathcoteAndHerran.com