Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?