-
1. Re: Filtering using Keywords, not specific list of values
Jim DehnerOct 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.
-
2. Re: Filtering using Keywords, not specific list of values
Soham Wadekar Oct 18, 2018 7:55 AM (in response to Maneesh Gupta) -
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.
-
4. Re: Filtering using Keywords, not specific list of values
Jim DehnerOct 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
-
-
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'.
-
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.
-
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.