Dependent Page Filters

Akhilesh1011
Contributor

Dependent Page Filters

I have a view published with 

        list-1 in rows

        list-2 in columns

        list-3 in pages

        list-4 in pages.

The dropdown for list-4 is dependent on item selection from list-3 and vice versa.

Filters are created for that but when applied, I couldn't see the option of Current context.

 

For Example,

List 3 has A,B items

List 4 has a,b,c items

 

When user selects 'A' from list 3 selector, then the list-4 selector should show 'a', 'b' for selection but not 'c'.

When user selects 'B' from list 3 selector, then the list-4 selector should show 'b', 'c' for selection but not 'a'.

 

Filter is the Boolean input for list 3 * list 4

There is no relationship between list3 and list4 except for the input filter.

 

Is there a way to achieve it without creating a hierarchy list between list3 and list4?

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Dependent Page Filters

@Akhilesh1011 

 

You will have to create Valid Combination List of (List 3 and List 4)

Once you have that list create a SYS Module based on Valid Combination list and map the items. It can be many to many mapping

Create two properties in Valid Combination list - one formatted as L3 and another L4. Write the formula and pull the data from SYS module into properties

Last step would be to enable dependent dropdown in the Filter line item

 

Misbah

View solution in original post

4 REPLIES 4
Misbah
Moderator

Re: Dependent Page Filters

@Akhilesh1011 

 

I think List 4 has to be dependent on List 3 and then you can enable the option of Dependent dropdown in List 4. See if below video helps.

 

Dependent Dropdowns - Anaplan Community

 

 

Akhilesh1011
Contributor

Re: Dependent Page Filters

Is there any way if list 3 and list 4 are independent?

Misbah
Moderator

Re: Dependent Page Filters

@Akhilesh1011 

 

You will have to create Valid Combination List of (List 3 and List 4)

Once you have that list create a SYS Module based on Valid Combination list and map the items. It can be many to many mapping

Create two properties in Valid Combination list - one formatted as L3 and another L4. Write the formula and pull the data from SYS module into properties

Last step would be to enable dependent dropdown in the Filter line item

 

Misbah

View solution in original post

Akhilesh1011
Contributor

Re: Dependent Page Filters

Thank You @Misbah