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

[Anonymous]

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.

[jwjackso · Accepted solution]

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]

it works perfect

Thanks a lot!