Update a filter based on picklist

BahalR
Contributor

Update a filter based on picklist

I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. 

 

I have a SYS module for List C. I would like to create a boolean in my SYS module that gets checked for any member of the list that a user selects in module 1

1 ACCEPTED SOLUTION

Accepted Solutions
ankit_cheeni
Super Contributor

Hi @BahalR 

 

Create a boolean line item in Module 1 that is always true. Something like this:

ankit_cheeni_0-1659595729981.png

Fruits is your List C. In the system module for List C (Fruits in my example), create a line item with this formula:

ankit_cheeni_1-1659595879370.png

 

Let me know if what you need is different

 

 

 

View solution in original post

5 REPLIES 5
rishabh01
Frequent Contributor

Hey @BahalR ,

I have a solution, can you just confirm that your SYS module for List C is also dimensioned by List A and List B?

Thanks,

Rishabh

Anurag0911
Contributor

Hey, Rishabh it is not recommended to have multiple lists in a SYS Module.

 

rishabh01
Frequent Contributor

Hey anurag you should mention SYS module as well, in other modules you can have multiple lists.

Although my bad, I missed that point.

ankit_cheeni
Super Contributor

Hi @BahalR 

 

Create a boolean line item in Module 1 that is always true. Something like this:

ankit_cheeni_0-1659595729981.png

Fruits is your List C. In the system module for List C (Fruits in my example), create a line item with this formula:

ankit_cheeni_1-1659595879370.png

 

Let me know if what you need is different

 

 

 

BahalR
Contributor

This worked beautifully. Thank you!