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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Background color expression on one column

Hi,

Please help me to change my background color expression that it will be only on the column '1-30 Days Overdue'.

My expression:

if([% of Reviews] >= 0.205, red(),

  if([% of Reviews]<0.205 and [% of Reviews]>=0.105, yellow(), green()))

1-30  overdue.PNG

1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

May be this

If([Display Period] = '1-30 Days Overdue',

     if([% of Reviews] >= 0.205, red(),

     if([% of Reviews]<0.205 and [% of Reviews]>=0.105, yellow(), green()))

)

View solution in original post

2 Replies
sunny_talwar
MVP
MVP

May be this

If([Display Period] = '1-30 Days Overdue',

     if([% of Reviews] >= 0.205, red(),

     if([% of Reviews]<0.205 and [% of Reviews]>=0.105, yellow(), green()))

)

Anonymous
Not applicable
Author

It works, Thanks!