topic Table: Change background cell color based on another cell value compared with current cell in QlikView https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47525#M1324154 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to replicate the attached Excel report in Qlikview.</P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">The objective is a matrix to evaluate 2017 sales against 2016 sales for each customer in each comm, div and business. </SPAN></P><P>Cells in green indicates values greater than previous year and Red background indicates that 2017 sales is lower than 2016.</P><P></P><P>please could you advise me on the most appropriate way to address this report?</P><P></P><P>Thanks in advance for your help!</P><P></P><P></P><P>Regards,</P><P></P><P>Alex.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT Anonymous 2026-01-26T18:19:17Z Table: Change background cell color based on another cell value compared with current cell https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47525#M1324154 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to replicate the attached Excel report in Qlikview.</P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">The objective is a matrix to evaluate 2017 sales against 2016 sales for each customer in each comm, div and business. </SPAN></P><P>Cells in green indicates values greater than previous year and Red background indicates that 2017 sales is lower than 2016.</P><P></P><P>please could you advise me on the most appropriate way to address this report?</P><P></P><P>Thanks in advance for your help!</P><P></P><P></P><P>Regards,</P><P></P><P>Alex.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47525#M1324154 Anonymous 2026-01-26T18:19:17Z Re: Table: Change background cell color based on another cell value compared with current cell https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47526#M1324155 <HTML><HEAD></HEAD><BODY><P>You can try using the below function in the background color for the expression:</P><P>=If(YR = '2017',If(sum(Amt) &gt; Below(sum(Amt)),Green(),Red()),White())</P></BODY></HTML> Thu, 08 Feb 2018 16:42:54 GMT https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47526#M1324155 jwjackso 2018-02-08T16:42:54Z Re: Table: Change background cell color based on another cell value compared with current cell https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47527#M1324158 <HTML><HEAD></HEAD><BODY><P>it works perfect</P><P></P><P>Thanks a lot!</P></BODY></HTML> Fri, 09 Feb 2018 01:54:56 GMT https://community.qlik.com/t5/QlikView/Table-Change-background-cell-color-based-on-another-cell-value/m-p/47527#M1324158 Anonymous 2018-02-09T01:54:56Z