hierarchy list and child list

KubotaNatsuki
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 @ChrisHeathcote 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

ChrisHeathcote
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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Misbah
Moderator

Re: hierarchy list and child list

@ChrisHeathcote 

 

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

 

Misbah

ChrisHeathcote
Community Boss

Re: hierarchy list and child list

ha!

Yes you are right.

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
KubotaNatsuki
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 @ChrisHeathcote explained) to apply it to child items pertaining to that parent.

 

Regards,

vinayvm

View solution in original post

KubotaNatsuki
Contributor

Re: hierarchy list and child list

Thank you for your reply!

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

ChrisHeathcote
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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA