Filtering multiple values in a field

Q&A
, , ,
9

Unfortunately contains does not work with multiselect parameters.

Another workaround that I can think of is a bit complex. Lets break it in steps.

  1. Configure the parameter control as free text taking input as comma separated value for example “CPB” to be entered by the user, or for multiple select “CPB, HPB” to be entered by the user. Fix a limit as how many values can one enter. For example, we can mention - allows only 15 values to be filtered at 1 time.
  2. create a calculated field using split to split the filter values based on comma as delimiter and check the substring presence for each string.
    e.g. ifelse(contains({field to be filtered}, split($filter paramater,‘,’,1),CASE_INSENSITIVE),1,
    contains({field to be filtered}, split($filter paramater,‘,’,2),CASE_INSENSITIVE),1,0)
  3. Use this calculated field to filter 1s.

For reference of what are the expected value that can be input in the filter parameter, you may need to add a separate text with list of available values.