Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting Cell’s Text Color if defined Background Color is used

 

Hi all,

 

I have a table with some defined formatting of Background Color (in Chart Properties -> Expressions -> some Column Name -> Background Color -> Definition).

For example the cell becomes red if the value in that cell is negative and so on.

 

I can format the Text Color I the same way, but it is too cumbersome because of all the parameters.

What I want to do is to check if the cell’s Background Color is red and if it is, then to change the Text Color to white.

 

Something like that under Text Color -> Definition:

 

if(Background Color = rgb(255, 0, 0), rgb(255, 255, 255),)

 

Is it possible to use such logic in Qlik?

 

If yes, than how can I do it?

 

Thanks a lot!

Best Regards

Timur

 

0 Replies