Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Make the Filter Tool Optional based on Drop Down Value

S-9
8 - Asteroid

Hi

 

I would like to use the action tool to update a filter based on values from the dropdown.  

The dropdown would also have a manual value "All" which if selected, should eliminate the filter tool from filtering anything and pass all records. 

 

Here is an example: 

Filter by Employee only has two values: Y and N

Add a Manual Text in drop down saying "All"

If "All" is selected, pass records for employees and non employees. 

 

It does not seem to work when I select All. Any information would help!

Thanks

 

 

2 REPLIES 2
TheOC
15 - Aurora
15 - Aurora

hi @S-9 !

Sorry for the delay in replying to you! This one had me stumped a little bit, but i've found a solution!

I'm sure theres a cleaner solution, but alas:

TheOC_0-1603834931838.png



within my macro:

TheOC_1-1603834948325.png



In a what feels like a hacky way - I am setting the value of each variable they can choose. Here Y and N are clear, but I add the OR conditional within the ALL selection. Wiithin my action:

TheOC_2-1603835001704.png



I have chosen to replace a specific string.


I have attached a packaged workflow with my macro, hope this helps!






Bulien
S-9
8 - Asteroid

that worked great! THANKYOU!

Labels