How to dynamically update list box to and use as a filter?

[jackdaniels]

Just starting to use the interface tools.

I want to be able to summarise the years in my data set then offer them as a list input to the filter tool. I can't seem to get it to work with more than one year selected.

 

[jdunkerley79 · Accepted solution]

Take a look at this article: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Dynamically-Create-List-Box-Values-From-Inpu...

Basically, you need to convert the years into column names and then the list box will do as you need.

Hopefully enough to get you going.

[Claje]

The other piece you might need is to update your Filter from "YEAR = 2010" to "YEAR IN (2010)"

Your list box should also be configured to create a comma separated list, and to replace 2010 in your filter.  That way, if you have 5 years (2010-2014), your filter will now read

YEAR IN (2010,2011,2012,2013,2014)

Whereas currently it reads YEAR = 2010,2011,2012,2013,2014 - which is not going to work.

[jackdaniels]

Ah, perfect @jdunkerley79

[jackdaniels]

Thanks @Claje !