Strange “CONTAINS” filter error with multi-value parameter (but I’m not using CONTAINS)

Q&A
, , , , , , , ,
1

Hello everyone,

I’m encountering an odd issue with a multi-value parameter with a multi-select dropdown control in my QuickSight analysis. Here’s what’s happening:

  1. Parameter for filtering visuals:
    I use a single parameter in a Custom Filter (type: EQUALS parameter) to filter some visuals.
  2. Same parameter in a calculated field:
    I also use this exact same parameter in a calculated field with the in() function, wrapped in an ifelse, like so:
    ifelse(in({columnA}, ${myParameter}), 1, 0)

Despite everything working perfectly (no broken visuals, the parameter works fine, and the calculated field returns correct results), I get this error message next to the parameter control:

Following items are incompatible with Multi-select drop down.
Please update/remove them to fix the broken visuals.

Filter - “CONTAINS” filter on columnB

The problem is:

  • I’m not using “CONTAINS” anywhere in my analysis.

  • None of the visuals are actually broken.

  • The calculated field works as expected.

Has anyone run into this issue before? Any idea why QuickSight would report a “CONTAINS” filter on columnB even though I’m not using it? Any suggestions on how to remove or prevent this message would be greatly appreciated!

Thank you in advance for any advice or guidance you can provide.

2

Hi @angelicamarrone,

Thanks for posting your question. To try to help resolve this, could I ask you to check a few things:
1. Are there other visuals or sheets in the analysis that have a filter applied that refers to ColumnB?
2. Is there a “Multiselect dropdown” control in the analysis for a parameter that links to dataset field: ColumnB?

Many Thanks,
Andrew

3

Hello @angelicamarrone

I haven’t seen this error before but I’m wondering if it has to do with the set up of your the filter that is connected to your parameter control. Can you send an anonymized screenshot of your filter that uses this parameter?

My guess is that when you created the filter you set it to “Contains” on the filter condition on one or more of your visuals.

4

Hi @angelicamarrone,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!