topic Re: Colour by expression in App Development

Colour by expression

Scott_Data — Mon, 17 Oct 2022 12:54:52 GMT

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?

Re: Colour by expression

Mark_Little — Mon, 17 Oct 2022 12:57:28 GMT

Hi,

Take a look at the wild match function

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

Re: Colour by expression

Scott_Data — Mon, 17 Oct 2022 14:32:39 GMT

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()))))