Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
the-null
Contributor III
Contributor III

How to add colour to if statement in table

Heloo,

so I have a table that is calculation some data, and I want to colour the row base on if statement:

nikanos1_0-1670312581670.png

The formula look like this: If(Iznos>[10-PROMET], 'ostvareno',if(Iznos<[10-PROMET], 'neostvareno')).

Can you help we to switch the words with colour.

Labels (1)
1 Solution

Accepted Solutions
the-null
Contributor III
Contributor III
Author

Hi,

and where can I found this two boxes?

I only have this option:

thenull_0-1670314335096.png

View solution in original post

2 Replies
Mark_Little
Luminary
Luminary

Hi,

You want to add this to the one of the colour expression boxes,

mark6505_0-1670314107830.png

If(Iznos>[10-PROMET], RGB(1,1,1),if(Iznos<[10-PROMET], RGB(2,2,2))) Changing the RGB Value to the colour you want

the-null
Contributor III
Contributor III
Author

Hi,

and where can I found this two boxes?

I only have this option:

thenull_0-1670314335096.png