Color only specific column

Anonymous — Wed, 09 Dec 2015 11:48:21 GMT

Hello,

I would like to color only the last column of kW in the following table.

I use the expression- if( KW<0.6*(Before(KW))and KW<>0,Yellow(150),if( KW>=1.4*Before(KW),green(150),if(KW=0,red(100))))

but as you can see it colors all the columns of kW.

Any ideas?

Re: Color only specific column

Gysbert_Wassenaar — Sat, 12 Dec 2015 16:00:19 GMT

You need to add another condition to select the last column:

if([solar_field_installation...]='Dec-215' AND KW<0.6*(Before(KW))and KW<>0,Yellow(150),if( KW>=1.4*Before(KW),green(150),if(KW=0,red(100))))

Replace solar_field_installation... with the real field name of the chart dimension.

If you need something more dynamic than a hard-coded value like Dec-2015 then perhaps something like Max(Total [solar_field_installation...]) will work.

topic Color only specific column in QlikView

Color only specific column

Re: Color only specific column