Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

Different BACKGROUND Color for different rows

  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

2015-01-07_11-52-16.png

2015-01-07_11-54-382.png

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Different BACKGROUND Color for different rows

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

)

)

)

View solution in original post

5 Replies
Highlighted
Esteemed Contributor

Re: Different BACKGROUND Color for different rows

HTH

Vikas

Highlighted
Partner
Partner

Re: Different BACKGROUND Color for different rows

Hmmm no...

I have different condition for each Rows...

Highlighted
Not applicable

Re: Different BACKGROUND Color for different rows

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

Highlighted
Luminary
Luminary

Re: Different BACKGROUND Color for different rows

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.

JV

Highlighted
Partner
Partner

Re: Different BACKGROUND Color for different rows

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

)

)

)

View solution in original post