Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare Column value in Straight table and change BG color in cell

I am using straight table in which I have Expected date and Actual Date column. Now I want to change BG color of Actual Date column to green if its <=Expected Date and Red if its greater that Expected date. Can you guys please help me.

1 Solution

Accepted Solutions
Not applicable
Author

Go to chart propeties->expressions. In Actual Date expression click on the "+" sign. You should be able to see background property there. Select that add expression as if([Actual Date]<=[Expected Date],Green(),Red()).

Kiran.

View solution in original post

1 Reply
Not applicable
Author

Go to chart propeties->expressions. In Actual Date expression click on the "+" sign. You should be able to see background property there. Select that add expression as if([Actual Date]<=[Expected Date],Green(),Red()).

Kiran.