You can use a combination of “ifelse” and “contains”.
Something like:
ifelse(contains(“datafield”,‘NC’) = true AND (all the others),‘Yes’,‘No’)
See also Link
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to handle does not starts with and does not ends with | 5 | 83 | March 17, 2025 | |
| How to filter rows based on whether a column contains a parameter value, and set a default control selection using that parameter | 1 | 59 | February 10, 2026 | |
| Custom on/off filter to exclude multiple values in a field | 3 | 122 | April 24, 2025 | |
| Campo de busca em table quicksight | 5 | 43 | December 20, 2024 | |
| Quick Sight query to return specified cirteria from multiple columns in a table | 7 | 85 | September 23, 2024 |