List Box Filter Problem

[Wm_Neil]

Relatively new to the Alteryx world, am having difficulty getting a list box to work with a filter. List box is reading from a file with both name and value, filter is set to custom, Operand is highlighted under the Operands tree branch.

[Wm_Neil]

View of app.

ScreenshotDebug

[NicoleJohnson]

Try selecting "Generate Custom List" in your List Box tool, and then changing your Action tool to point to the Expression instead. 

For example, if your filter is configured to filter for [Month] IN ("01"), then you would point your Action tool to the Expression, and then check the box and modify the "Replace a specific string" configuration at the bottom to replace only the 01 portion of the string. 

This way, if you selected months Jan, Feb, and March in your List Box, it will replace the "01" in your filter formula to read [Month] IN ("01","02","03"). 

See attached for example!

Cheers,

NJ

[Wm_Neil]

Nicole, thanks for the response. I do have Generate Custom Selected and pointing to the statement date file. This feeds the list box and populates with a list of dates to select when running the app. The action tool then points to Operand - value., however, this is not working. If I change it to expression, it does not pull data. I can't view your app, I'm using 18.3.7.5.

[NicoleJohnson]

Are you selecting more than one date? If so, you'll want an IN statement in your filter, not an = sign. That way if the user selects more than one date, your query will still work.

[Stmt_Date] In ("2019-01-15")

Additionally, you will need to use the Expression section at the top, not the Operand item you are currently pointing to in your Action tool. The Operand you are referencing will only work for Simple filters, and you're using a Custom one. If you configure your Action tool to update the Expression instead, I believe it will work.

NJ

[Wm_Neil]

How can I post my app for you to look at, the attachment tool won't take it.

[NicoleJohnson]

You'll need to "package" it, the Community doesn't accept .yxwz files as attachments for some reason... select Options > Export Workflow and then your app will be packaged as a .yxzp file that you can share in a post.

[Wm_Neil]

Thanks so much for all the help!

[NicoleJohnson · Accepted solution]

Found the issue - update your configuration as highlighted below (you only want your list of dates to replace the initial date used to configure the workflow, not replace the entire filter formula string):

NJ

[Wm_Neil]

NJ, you are a gem! Learned a lot , thanks so much.