topic Re: expression for background colour on columns output in QlikView

expression for background colour on columns output

rcorcoran — Tue, 09 Jul 2019 10:53:24 GMT

I have a column in Table in QV and I need to adjust the background colour depending on the figures in three other columns.

So if Column 6 and Column 17 are >6.4% then it should show purple but if Column 6 Column 17 and Column 18 are >6.8% then it should show in blue.

The problem with my set analysis is that it will show the first part of the expression as in the purple colour but as I am adding in an extra column in Column 18 where I want where the three columns data are >6.8 colour blue is not working and they are staying purple.

//purple
if(Column(6)>'6.4%'and Column(17) > '6.4%',RGB(204,192,218),
//blue
if(Column(6)>'6.8%'and Column(17)>'6.8%'and Column(18) > '6.8%' ,RGB(0,176,240),
white()

see attached as explanation

Re: expression for background colour on columns output

olivetwist — Tue, 09 Jul 2019 17:27:17 GMT

You just need to change the order of your nested IF. Put the one with the most conditions first. Below worked for me

if(COLUMN(6)>'6.8'and COLUMN(17)>'6.8'and COLUMN(18) > '6.8' ,RGB(0,176,240),
if(COLUMN(6)>'6.4'and COLUMN(17) > '6.4',RGB(204,192,218),white()))

Re: expression for background colour on columns output

rcorcoran — Wed, 10 Jul 2019 09:32:58 GMT

Thank you so much works perfectly