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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to color column in straight table when value is high or low?

Hi,

I have added below query to make "RED" if plan is more than actual and if actual is more than plan "GREEN"

if(Avg([Plan PSD_FM])> Avg([Actual PSD_FM]),RGB(255,99,71),RGB(50,205,50))

but in 0 its shows "GREEN" I want to make it "WHITE" in 0. please find the image in the attachment

10 Replies
jagan
Partner - Champion III
Partner - Champion III

Click Correct Answer and Helpful Answer button/links for the replies which helped you.

Regards,

Jagan.