You have raised an interesting point about not knowing what your users are going to want to choose, however, I am unsure of its relevance to this thread as Leo was asking about a given set.
Maybe you should start a new thread to prevent confusion.
But, on your point, this is the fundamental problem within any type of report, it is usually a given that a user will only be able to select from a pre-defined list this includes where-clause filtering in sql or the filters in Excel.
However, a probable solution that could work involves the use of a sheet filter as proposed by Jonathan but with an additional step to allow for a searchable value:
- Create your viz (item(s) to be filtered)
- Create a second sheet which is just a list of filterable and selectable items
- Create an empty parameter for type in
- Create a filter that reacts to the the value of the parameter, something like Left(Lower([Sub Category]),2) = Left(Lower([Parameter 1]),2) Or [Parameter 1] = ""
- Drag the filter on to the sheet filter and select "T"
- Drag your viz, the parameter and the sheet filter to the dashboard right-mouse select the filtering sheet and select "Use as filter"
Now when you type into the box, the filtering sheet is filtered but crucially, only items that match your search parameters remain allowing you to then select which of these you want to use to filter the main viz.
I have attached an example: https://public.tableau.com/profile/steve6460#!/vizhome/151303-Typeinfilter/Dashboard1
This is just a very basic and rudimentary version and by expanding the filtering criteria, you do not need to be limited to just items that match the input of "of" for example of "Office"; similarly, you could have the first character matching so all items beginning with the letter "c" for example.
Dear Steve Sir,
When we are creating quick filter through Set , are we seeing any performance difference? Could you please explain what's the benefit of creating a Quick filter through "set" rather than simple traditional filter process?
I haven't tested for a performance difference between either method, though that is not to say such testing cannot be undertaken from the logs.
For this post, the op was asking for a method that would allow him to create a defined list of filterable items,whereas simply using a quickfilter will provide all available items unless the qf is set to Show Relevant Values and another filtering operation is pre-defined to filter-away items that should not be altered.
Dear Steve Sir,
I have created a new thread regarding the same question. Would you like to have a look and share your valuable thoughts over there as well.
Thanks Jonathan. Any idea whether this has been submitted as an idea?
1 of 1 people found this helpful
I didn't see this suggestion...
Using SuperStore as the example, create a parameter that allows typing in a comma separated list of Regions such as "West, East, Central". Then create a filter as follows:
[Region] = TRIM(SPLIT([RegionParameter], ",", 1))
[Region] = TRIM(SPLIT([RegionParameter], ",", 2))
[Region] = TRIM(SPLIT([RegionParameter], ",", 3))
User can type "West" or "West, East" or "Central, East, West". Any garbage that is typed in that doesn't match the data is ignored. This will take up to 3 values in the parameter list; if more than 3 are entered they are simply ignored. If you need more values, add more lines incrementing the token number parameter of the SPLIT function as needed.
hello Ron Willes,
I have implemented the above logic to select up to 3 values through parameter. and it works fine on desktop.
But I need to provide these value through URL. and when I provide comma separated value through URL, looks like it just taking the first one only.
So my solution looks like this.
[Region] = TRIM(SPLIT([RegionParameter], "$", 1))
[Region] = TRIM(SPLIT([RegionParameter], "$", 2))
[Region] = TRIM(SPLIT([RegionParameter], "$", 3))
I have a similar situation but I need to select Multivalued parameters(i.e. select the columns) through check box (filters). How can I achieve that.
so, do you just basically wants to change the field/column with parameter?
For example, I have 5 columns - Name, Age, Country, Height, Gender.
With Parameters I can give the user to select any one of them but how can I give the option to the user to choose more than one column.