Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

itamarchubb
New Contributor III

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
MVP
MVP

Re: Background color expression on one column

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()))

)

2 Replies
MVP
MVP

Re: Background color expression on one column

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()))

)

itamarchubb
New Contributor III

Re: Background color expression on one column

It works, Thanks!

Community Browser