Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

acepeda71
New Contributor

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
Contributor III

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

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

2 Replies
jwjackso
Contributor III

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

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

acepeda71
New Contributor

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

it works perfect

Thanks a lot!