Create a Filter to show all the elements of that level based on selection in hierarchy

Hello Community members,

Requirement Details:

I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I achieve this scenario.

Looking for your thoughts. Thanks in Advance.

Accepted answers

shivanandhonnalli

@Ajaykumar08ns Can you try this .

Create 5 Levels of LI in Custom Filter module where User is Dimension.

Update the formula in A5 Module LI which is dimensioned by User and A5 Level - (isblank(Custom Filter A1) or Custom Filter A1 = A1 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A2) or Custom Filter A2 = A2 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A3) or Custom Filter A3 = A3 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A4) or Custom Filter A4 = A4 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A5) or Custom Filter A5 = A5 Level LI from Module at A5 Level)

Hope it helps!

All comments

shivanandhonnalli

@Ajaykumar08ns

1.Create a Module at A5 Level, create LI (A4 level hierarchy as format) ,Publish it on the UX

2.Create Custom Filter LI (A4 level hierarchy as format) at user dimension

3. create LI in the A5 Level Module , the LI has to be dimensioned by A4 Level and User dimension.

4, write a formula - isblank(Custom Filter LI) or Custom Filter LI = A4 Level LI from Module at A5 Level.

Hope it helps

Ajaykumar08ns

@shivanandhonnalli - It's not only specific to A4 Level, If user selects list item from a particular level ie.,A1 to A5 I have to display all elements from that specific level.

shivanandhonnalli

@Ajaykumar08ns Can you try this .

Create 5 Levels of LI in Custom Filter module where User is Dimension.

Update the formula in A5 Module LI which is dimensioned by User and A5 Level - (isblank(Custom Filter A1) or Custom Filter A1 = A1 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A2) or Custom Filter A2 = A2 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A3) or Custom Filter A3 = A3 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A4) or Custom Filter A4 = A4 Level LI from Module at A5 Level) AND

(isblank(Custom Filter A5) or Custom Filter A5 = A5 Level LI from Module at A5 Level)

Hope it helps!

Ajaykumar08ns

Hello @shivanandhonnalli - Thank You very much for your responses.

This current logic is not functioning as intended. At present, when I select an A5 item from the custom filter, the boolean value is set to true only for that specific selected item. Similarly, when I select an A4 item, the Boolean value is applied as true for all A5 items under the chosen A4 item.

However the expected behavior is as follows:
1. when an A5 item is selected from the custom filter, the boolean value should be set to true for all A5 items, regardless of which one is selected.

2. When an A4 item is selected from the custom filter, the boolean value should be true only for all A4 items, without affecting any A5 items.

which means I need to look at the level that user is selecting from custom filter and filter all items from that specific level itself. Not the child's

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…