7 Replies Latest reply on Oct 25, 2018 10:47 AM by Maneesh Gupta

Filtering using Keywords, not specific list of values

Maneesh Gupta Oct 18, 2018 7:48 AM

Hello, is there a way to add a filter with a list of specific keywords, rather than a list of values.

For example,

For State, there is a pre-defined list:
(1) New
(2) North
(3) South
(4) Texas
(5) Virginia

And if the user selects 'New', the data gets filtered with any State with 'New' (New Hampshire, New Jersey, New Mexico, New York).
If they select 'Virginia', data with Virginia or West Virginia is returned.

Thanks,

Maneesh

1. Re: Filtering using Keywords, not specific list of values

Jim Dehner Oct 18, 2018 7:54 AM (in response to Maneesh Gupta)

Good morning
the way to have users provide input into tableau is through Parameters - you then match the parameter to a calculation that can be used as a filter

the parameter would look like this

the filter like this
place on the filter shelf ad set to True returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Like Show 0 Likes(0)

Actions
2. Re: Filtering using Keywords, not specific list of values

Soham Wadekar Oct 18, 2018 7:55 AM (in response to Maneesh Gupta)

Hi Maneesh,

Did you try the wildcard filtering?

Please let me know if this works.

Thanks,
Soham
Like Show 0 Likes(0)

Actions
3. Re: Filtering using Keywords, not specific list of values

Maneesh Gupta Oct 18, 2018 8:25 AM (in response to Jim Dehner)

Hi Jim, thank you very much for the quick response.

2 questions:

(1) After I show filter, my options are (All), Null, False, True.
Not New, North, South, Texas, Virginia

(2) I want to show default of all 50 States. Not All of my keywords.

Thanks.
Like Show 0 Likes(0)

Actions
4. Re: Filtering using Keywords, not specific list of values

Jim Dehner Oct 18, 2018 8:50 AM (in response to Maneesh Gupta)
see the attached

you don't show the filter - just set it to true - the parameter is you input to the filter
change the parameter to include "All"
then the filter becomes

it will return this
or this

Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

state filter.twbx 2.4 MB
Like Show 0 Likes(0)

Actions
5. Re: Filtering using Keywords, not specific list of values

Maneesh Gupta Oct 18, 2018 9:38 AM (in response to Jim Dehner)

Thank you again, Jim.

Only thing I needed to add to your solution was to right click the Parameter and select 'Show Parameter Control'.
Like Show 0 Likes(0)

Actions
6. Re: Filtering using Keywords, not specific list of values

Maneesh Gupta Oct 18, 2018 9:38 AM (in response to Soham Wadekar)

Thank you Soham.

I need a pre-defined list. That's why Wildcard filtering will not work.
Like Show 0 Likes(0)

Actions
7. Re: Filtering using Keywords, not specific list of values

Maneesh Gupta Oct 25, 2018 10:47 AM (in response to Maneesh Gupta)

There is an additional functionality needed. The user should have the ability to select multiple keywords.
In the filter, I am currently only able to select single value.

If the user selects 'New' and 'Virginia', the data should get filtered with any State with 'New' (New Hampshire, New Jersey, New Mexico, New York) or 'Virginia' (Virginia, West Virginia).

If possible, please let me know what changes to the above solution can fix this. Thanks.
Like Show 0 Likes(0)

Actions