Filter for multiple string values in one cell

tableaucommunity@tableau.com — Thu, 22 May 2014 12:13:19 GMT

Hello,

I have an excel filed that is structured like this:

Name	Club	Other Clubs	Equipment
Name 1	Club 1	Club 2, Club 3	Socks
Name 1	Club 1	Club 2, Club 3	Shorts
Name 2	Club 2	No	Socks
Name 3	Club 3	Club 1	Shirt

What I want to do is to be able to apply a filter for all the Clubs.

So that when I select Club 1 i get Name 1 and Name 3

Club 2 I get Name1, Name2

Club 3 I get Name1, Name 3

Is there a way to do that. I know that you can make a joint filter out of two categories, but is there a way to separate multiple values that are in one cell?

Thank you very much!

Search for multiple strings and display them in one cell

tableaucommunity@tableau.com — Fri, 10 Jan 2014 11:48:22 GMT

Hello there,

I'm pretty new to this software, just started to experiment with it. I'm preparing to do a bigger project so now I'm in the testing phase.

I have this database that is formatted like this:

Country

Type

Afghanistan

Contraception

Bangladesh

Retroviral

Bangladesh

Contraception

Bangladesh

ARV

My goal is to return all the strings from the "Type" field for the same "ID" value and put them in a "Tooltip" on a map.

So far, this is what I've accomplished, with the use of <ATTR(Type)>. It works well for 1 value, but for the countries that have multiple values I get an asterisk...

Is this a formatting problem? Thanks for any suggestions...

Content in Tableau Community Forums

Filter for multiple string values in one cell

Search for multiple strings and display them in one cell