Colour by expression

[Scott_Data]

Hi all, 

I've got a column (Foundation), which contains string data. I'm trying to colour background by expression, below is my expression. 

= IF([Foundation]='Completed', Green(),
IF([Foundation]='Not Started', Red(),
IF([Foundation]='Off Track', Red(),
IF([Foundation]='On Track', Yellow()))))

The string "Completed" works fine, the other 3 don't work as there are other characters after, such as "On Track 88%".  Is there a wildcard symbol such as '*' which will then colour the backgrounds if a string field contains part of my string example? 

[Mark_Little]

Hi,

Take a look at the wild match function

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalF...

[Scott_Data]

Thanks Mark. I find those "Help" sections very unhelpful. They aren't very good at explaining the basics. They expect everyone to be a fully fledged developer, which I am definitely not. Would be helpful if there were examples. I managed to get this working for future reference if anyone has the same question as me. 

=if(WildMatch(Foundation,'*Off Track*'),red(),
if(WildMatch(Foundation,'*Not Started*'),red(),
if(WildMatch(Foundation,'*On Track*'),yellow(),
if(Foundation = 'Completed',Green()))))