Dynamic Filter on Multiple Values

Hi! I have a workflow using an Alteryx Application allowing the user to multi-select values filtering the dataset further. Currently, I'm using a "Basic Filter" with an operator set to "equals" which filters the data set based on a value. If the end-user selects one value, the filtering works properly, but what is the configuration for multiple values - similar to an "IN" function in SQL.

Claim Settlements_Agreements.yxmd

Workflow

Accepted answers

JoeS

Hi @ACharChar

You should be able to achieve what you need with the below set up (I have also attached the workflow).

What you need to do is update the Generate Custom List part of the list box to create a comma separated list like:

Image 1.png

Update the filter to use an in statement in the custom option:

Image 2.png

And lastly update the action tool to change the list bit of the in statement:

Image 3.png

Claim Settlements_Agreements.yxwz

All comments

apathetichell

Hi - so you can use listbox to dynamically filter on multiple fields but it has to be connected to an action tool. I do not believe you can get a concatenated string of listbox values out of the action tool to use in a contains or in function....

JoeS

Hi @ACharChar

You should be able to achieve what you need with the below set up (I have also attached the workflow).

What you need to do is update the Generate Custom List part of the list box to create a comma separated list like:

Image 1.png

Update the filter to use an in statement in the custom option:

Image 2.png

And lastly update the action tool to change the list bit of the in statement:

Image 3.png

Claim Settlements_Agreements.yxwz

ACharChar

@JoeS, that did the trick! Relatively straightforward. I hope others find this beneficial, I searched the community extensively for a solution.

apathetichell

@ACharChardid you get @JoeS 's strategy to work? My expectation was that would solve your problem but in practice it wasn't working for me.

ACharChar

@apathetichell , it did work on the first try.

JoeS

@apathetichell wrote:
@ACharChardid you get @JoeS 's strategy to work? My expectation was that would solve your problem but in practice it wasn't working for me.

Hi @apathetichell

What is it that's not working for you? Did you want to post up your workflow?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703