Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Ketaki123
Contributor
Contributor

Colour coding

I am new to qliksense and I have been tasked with building a dashboard. Can someone help me with the following 2 questions please?

1. I want to color a cell in a table if it contains this character '*', I am unable to write the relevant code for this in the background colour expression section

2. I have a column X that has dates and several other columns that have these dates as their title.

I want to colour these columns if the title == column X date if that makes sense.

 

Please let me know, thanks!

Labels (3)
1 Reply
henrikalmen
Specialist II
Specialist II

Something like if(wildmatch([fieldname], '*'&chr(42)&'*'), lightred()) as background color expression should probably work. Since the asterisk (*) is a wildcard character you can't use it directly in a wildmatch. But I would think that if you want to color fields that holds the exakt value '*' you could simply do if(fieldname='*', lightred()).

I'm not sure I understand your second example, perhaps you could provide a visual example?