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

Wed, 25 Nov 2020 16:16:04 GMT

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

topic Formatting Cell’s Text Color if defined Background Color is used in QlikView

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