Updating a Filter with Multiple values using a listbox in an alteryx app

Hello,

I am building an alteryx app to look at sales in a specific store group. My plan was to use a listbox to allow the user to select which group of stores that they would like to analyze. This listbox would then update a filter that is connected to a join. This join filters out the specified stores from the original dataset. However, so far this method only returns a workbook with 1 store in the list. I have attached a picture of my input for the listbox, my filter, and my workflow. Any advice?

Alt Issue Data.PNG

Alt Issue Filter.PNG

Alteryx Issue Workflow.PNG

Apps

Accepted answers

patrick_digan

@lharris17 Thanks for posting the workflow, that makes it a lot easier to debug! Here is what I did:

I ran the debugger:

I then looked at the filter to see that it's not configured as expected. Also note that the comment added shows you the list box is trying to pass "Type A, Type B, Type C":

Back in your original flow, you have your action tool selecting the custom line instead of your formula 1 line above it:

But from the debugger I see that it's passing Type A, Type B, Type C (instead of the store numbers). So i tweaked your flow to transpose the store list, apply a filter to it, and then join that back to your sales data.

Hope that helps!

Test flow.yxwz

All comments

patrick_digan

@lharris17 I would use the interface designer >>> Test View to try out my app. You can use the Open Debug then to see what is being populated in the filter tool. Hopefully this can help you figure out what's wrong. If I had to guess what's wrong, be sure your list box is generating a custom list with a comma as the separator:

The action tool can cause trouble, but the fact that it's returning 1 store in the list means it's less likely a problem with the action tool.

lharris17

I am still having some issues, would you mind looking at my workflow?

Test flow.yxwz

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703