Hi,
I have a FILTER Tool with This Expresion -> [tipo] NOT IN ("[X]")
"[X]" is a connection comming from a list box. I want this to filter just the selected items in the List Box... But this is not working.
Some one have an Idea how to do this?
Thanks
MC
Solved! Go to Solution.
Not completely sure about exactly what's going on (maybe the options in the .csv), but here is a workaround:
Your workflow should look like this:
So, you have to:
- Add a Formula Tool before your Filter Tool with this config:
Change the Filter like this:
Now, edit your Listbox to get back those double quotes:
And finally, edit the Action Tool like this:
Run the module, now it should select the multiple options.
You are the best!!
Thanks!
:)
Hi all,
I'm new to alteryx and just joined the community. I realize this post is very old, but this is what I was finding with my google search when I was struggling to get my list box to filter from an app as intended. I got it working and figured I'd post it for anyone that might find this post in much the same way I did, who is looking for a simple solution.
I am filtering a field [industry] from a list box in this example. The image below shows how I configured the tools. Hopefully this helps. Took me a while to step back and figure out to include the quotes in the action tool string replacement.
User | Count |
---|---|
18 | |
14 | |
10 | |
6 | |
6 |