Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

List Box Filter Problem

Meteoroid

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.

 

 

Highlighted
Meteoroid

View of app.

 

ScreenshotScreenshotDebugDebug

Highlighted
Magnetar
Magnetar

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

Highlighted
Meteoroid

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.

 

List box.PNGAction Tool.PNG

Highlighted
Magnetar
Magnetar

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.

 

ListBoxFilter.JPG

 

NJ

Highlighted
Meteoroid

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

Highlighted
Magnetar
Magnetar

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.

Highlighted
Meteoroid

Thanks so much for all the help!

Highlighted
Magnetar
Magnetar

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):

 

FilterList.JPG

 

NJ

Highlighted
Meteoroid

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

Labels