Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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!