topic Re: Different BACKGROUND Color for different rows in QlikView

Different BACKGROUND Color for different rows

steeramp — Wed, 07 Jan 2015 11:01:42 GMT

Hallo everybody,

How can make differents background color for my column "en%" for each rows ?

Example :

for GROUPE 6 , if en% >0 , color Green --- if en% <= 0 , color RED
for GROUPE 3 , if en% >0 , color RED --- if en% <= 0 , color Green
for GROUPE 4 , if en% >0 , color RED --- if en% <= 0 , color Green

Re: Different BACKGROUND Color for different rows

vikasmahajan — Wed, 07 Jan 2015 11:03:40 GMT

HTH

Vikas

Re: Different BACKGROUND Color for different rows

steeramp — Wed, 07 Jan 2015 11:21:06 GMT

Hmmm no...

I have different condition for each Rows...

Re: Different BACKGROUND Color for different rows

Wed, 07 Jan 2015 11:56:12 GMT

Hi Steeven.

I think this might work.

in that expression tab, left of en%, click that '+' sign, then click background color, on your right click definition, then write. ohh by the way what is the column that contains your groups(GROUP3,4 and 6), let suppose u called it 'Group', then write

if(Group = 'Group3' & en% > 0,Green(),if(Group = 'Group4' & en% >0,Red(),if(Group = 'Group6' & en%>0,Red(),Green()))).

Hope this helps

Re: Different BACKGROUND Color for different rows

jvitantonio — Wed, 07 Jan 2015 11:56:13 GMT

Hi,

this can be done from the Background Color expression.

Go to your expression, click on the + signs, and add your conditions in the Background Color option.

I'm attaching an example.

Re: Different BACKGROUND Color for different rows

steeramp — Wed, 07 Jan 2015 13:05:35 GMT

Hi everyone,

In this way I have find the solution in the Background Color option

If(rowno(total)=1,If(if en% >0,LightGreen(),LightRed()),

If(rowno(total)=2,If(if en% >0,LightRed(),LightGreen()),

If(rowno(total)=3,If(if en% >0,LightRed(),LightGreen()),

)