Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
acepeda71
Contributor II
Contributor II

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

acepeda71
Contributor II
Contributor II
Author

it works perfect

Thanks a lot!