Filter for multiple values, Analytic App
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to figure out how to incorporate filtering for multiple values in my analytic app filter tool.
Is it possible to filter for multi values ie Toronto|New York|Miami ?
Solved! Go to Solution.
- Labels:
- Custom Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@wonka1234 you need to add the list box for multiple selections and filter the city. The below post might be helpful for your use case
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wonka1234
You can use a List Box tool which will allow the user to select multiple values and have the output generate a custom list similarly to concatenating string in a Summarize tool.
Set up your Filter tool to use the IN operator and then have your action tool update the values to include. Attached is an updated version of your workflow with that setup.
This option wouldn't be compatible with the other user definable options you configured so you'd have to find how to fit this logic into the mix.
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jrgo only issue with this is that the values are static. I would need them dynamic dependent on the input file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you mean by 'dynamic' to change the list of options according to your selection, I would use "Chain App" technique.
You may find this weekly challenge applicable to your use case : Challenge #175: Tire Size Calculator
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I made a sample Chained App to let the user choose columns to filter and prepare the list box according to the selected column.
It still needs some enhancements to make it fully "dynamic" (e.g. now it only supports strings, not numbers).
While I believe they are doable and may become a good exercise for making Apps,
it would take more effort to implement this kind of interactive operation on Alteryx than Tableau.
Good luck.
Step 1: Prep list
Step 2: Select Column to Filter
Step 3: Filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Yoshiro_Fujimori thanks! how about a non chained app with a text input for the user? Ie Filter Value 1 | Filter Value 2 ,etc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@wonka1234 I'm pretty sure I solved something earlier and did what you want now:
In Field 1 I have various locations:
I want user to be able to filter on multiple, let's say New York and Place1:
Success!
Just change this part for your case:
All the best,
BS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BS_THE_ANALYST interesting.. but what if you dont know what column to filter on? It looks like this will only work if your filtes for a City column. What if there a column for Names that a user wantts to filter on
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, this would probably be where chained apps would kick in. The column selection would impact what values the user would see for their filtering choice, hence needing the output of one as the input of the other.
If they don't have the choice of the column selection to filter on, then this is one way to execute the filtering dynamically.
