Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.