Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Basic column conditional formatting with pattern match / "contains" operator
3276546
Rank 1 - Community Starter
Hi,
I'm trying to set a conditional format on a column if it contains some text. Is this possible? The GUI does not give "Contains All" or "Contains Any" as an operator.
Solutions I have tried and failed:
- Creating a second column to base the condition on (e.g. case when X contains Y then 1 else 0 end). The field is the measure of a pivot table and so a second column will not work.
- Editing the XML. I tried changing the code from <sawx:expr xsi:type="sawx:comparison" op="equal"> to <sawx:expr xsi:type="sawx:list" op="containsAll"> but no luck.
Is there a different XML format or another way to do this?
0