Answer

1. Right-click on [State] in the left-hand data pane and Create > Set…
2. In the Create Set dialog, give the set a name and click OK. In this example, the set is called "State Set A"
3. Right-click on [State Set A] in the data pane and tick Show Set
4. Repeat steps 1-3 to for "State Set B"
5. Select Analysis > Create Calculated Field
6. the Calculated Field dialog box that opens, do the following, and then click OK:
   1. Name the calculated field. In this example, the calculated field is named "Selected states filter"
   2. In the formula field, create a calculation similar to the following:

      [State Set A] OR [State Set B]

7. Create a calculated field with a name like "Selected States Colour" with a calculation similar to the following:

   IF [State Set A] AND [State Set B]
   THEN 'Both'
   
   ELSEIF [State Set A]
   THEN 'A'
   
   ELSEIF [State Set B]
   THEN 'B'
   
   ELSE 'not selected'
   
   END

8. Double-click on [State] in the data pane to create the map
9. Drag [Selected States Colour] to Colour on the Marks card
10. Drag [Selected states filter] to the Filters shelf
11. In the Filter dialogue, tick True and click OK

1. Click the down arrow next to Dimensions in the data pane and select Create Parameter…
2. In the Create Parameter dialog, do the following and click OK:
   1. Name the parameter. In this example I will call it "Multi-Search"
   2. For Data Type, choose String
3. Right-click [Multi-Search] in the data pane and select Show Parameter Control
4. Select Analysis > Create Calculated Field
5. In the Calculated Field dialogue box that opens, do the following, then click OK:
   1. Name the calculated field. In this example, the calculated field is named "String Match (contains)"
   2. In the formula field, create a calculation similar to the following:

      [Multi-Search] = ""
      OR
      CONTAINS([Multi-Search],[State])

6. Drag [String Match (contains)] to the Filers shelf
7. In the Filter dialogue, tick True and click OK

Additional information

Option 1 Limitations:

• Sets cannot be shared across data sources
• Sets cannot contain additional values outside what is in the data, but values can be aliased

Option 2 limitations:

• String functions can slow down performance
• The values must be entered manually exactly as they appear in the data (tick boxes will not work)
• The other limitations of parameters still apply
• More advanced string parsing (removal of metacharacters, using a comma with a space as a separator, exact match, etc.) may require additional code