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

Dynamic Filter Macro

Chris_Waspe
7 - Meteor

Hello Alteryx Community

 

I am attempting to create a dynamic filter in which the user is able to first select the field by which they would like to filter and then chose from the values of that field to apply to the filter. So the second drop down should dynamically change depending on the field chosen in the first drop down. The attached workflow uses the Superstore data as an example. Please help! Thank you.

 

Christopher Waspe

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Chris_Waspe ,

 

if if this is truly dynamic, the macro would know the field domain values for the filter. I am assuming that based upon a static set of field values that you would choose from a static set of domain values. 

 

Instead of drop downs, please investigate the use of a tree to select your filter components and use an action to convert the selection into an IN clause. 

 

Cheers,

 

Mark

 

Ps  here's a sample macro:  https://gallery.alteryx.com/#!app/Contains-In-List/5a5903fda18e9e2508e5ae0d

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
rafalolbert
ACE Emeritus
ACE Emeritus

Hi @Chris_Waspe,

 

It's a pretty challenging task and to my knowledge there is no possibility to refresh the app based on the first drop-down selection, for the 2nd drop-down to get dynamically populated in a cascading manner (possibly chained app, but i don't have much experience with this and in my opinion the UX experience of the end user is affected).

 

You could consider exposing all options pre-canned for the end user or concatenating field and values in key->value pair sorted strings and achieving it this way (this depends on how many value you expect and how readable this would be in your specific use case).

 

This is how far i got (this is not truly dynamic, but follows the selections systematically), hope this helps:

 

img1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

estherb47
15 - Aurora
15 - Aurora

Hi @Chris_Waspe 

I've done something similar with chained apps. Here is a great learning video on the topic: https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

Basically, you create an app where you're choosing the first drop-down item. That app launches the next app, which has the subsequent drop down and the rest of the process. I'm attaching a very simple example where I've used checklists, but you can do the same with drop-downs.

A few things to keep in mind.

  1. The Output to yxdb that will be called on in the second app needs to have Name and Value columns
  2. The first app will call the second app on success. This is set up in the Interface window
  3. When you bring in the list for the drop-down in the second app. you'll be connecting to an EXTERNAL SOURCE (the yxdb from the first app) 



It's pretty easy to do.

 

Let me know if this helps

 

Cheers!

Esther

Chris_Waspe
7 - Meteor
Thank you very much for the help. This definitely seems like the best solution and does what I need to do.
Labels