How would you setup an interface tool to update a filter (on Year) that allows a user to select 1-N years to pass through the filter? ([Year] is not a date; it refers to a fiscal period.
[Year] in ("2011","2010","","")
YEAR |
2009 |
2010 |
2011 |
2012 |
2013 |
Solved! Go to Solution.
Hi @hellyars
I show the sample of using the DropDown tool.
When we use the Interface tools, basically we set the Action tool to rewrite the parameter of the tools.
Action tool setting is as follows when we use the Basic filer.
Filter setting is as follows.
Please refer attached sample workflow.
Hi @hellyars
To select multiple years, use a List Box/Filter combination
Configure the filter using the "IN" syntax, [Year] in (2009). Configure the List box to output a csv list with no quotes
And finally set the Action tool to Replace a specific string with 2009 being the target
The criteria gets replaced with the user selected values when run
Dan
Hi @hellyars
If you are looking to show a filter based on range 1-N years. You can design your analytic app like below. Where you can use 2 dropdown list to set lower & upper value of the range and use its respective filters to change the values like.
Output:
Hope this helps 🙂
Hi @hellyars
And here is a neat trick if you are interested. Lets say you do not want to update the value in dropdown tool configuration with new options (below config) each time data is updated. Lets say you want the options to dynamically update.
Here is the trick. Drop down & List box tool has this option where you can pass field names from previous tools as display options. What you can do is take the column which has values, use formula tool to create a dummy column, use crosstab tool to convert values into column name like below. And then pass it to drop down tool as field names input. Now this will dynamically update the options each time data is updated.
Hope this helps 🙂
@danilang That's exactly what I needed.
@atcodedog05 Thank you. This is setup for a range (vs. a random selection), but I have use for this.
@AkimasaKajitani Thank you as well. I was looking for a way to define a range, but I can learn from this.
Thank you all.