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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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?