Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Table: Change background cell color based on another cell value compared with current cell

Hello,

I need to replicate the attached Excel report in Qlikview.

The objective is a matrix to evaluate 2017 sales against 2016 sales for each customer in each comm, div and business.

Cells in green indicates values greater than previous year and Red background indicates that 2017 sales is lower than 2016.

please could you advise me on the most appropriate way to address this report?

Thanks in advance for your help!

Regards,

Alex.

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

You can try using the below function in the background color for the expression:

=If(YR = '2017',If(sum(Amt) > Below(sum(Amt)),Green(),Red()),White())

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

You can try using the below function in the background color for the expression:

=If(YR = '2017',If(sum(Amt) > Below(sum(Amt)),Green(),Red()),White())

Anonymous
Not applicable
Author

it works perfect

Thanks a lot!