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.
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
View of app.
ScreenshotDebug
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,
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.
How would I filter for any item in the list?
I found a rather easy way to do this without using Macros or Apps...
