Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Colour of background depending of cell value

Hi guys, i'm trying to set background colors depending of cell values in qlik sense table, for examen if(avg([Rec_pesobrutot]) >= 43000 and <= 45000, "some colour"), if(avg([Rec_pesobrutot]) > 45000 and <= 47000, "some colour"), etc

I found a topic with same question but i'cant open others qlikview files, so if anyone can write the expression i'll be very thankfully.

King Regards,

Gerd Neumann

Captura de pantalla 2015-11-17 a las 10.46.42 a.m..png Captura de pantalla 2015-11-17 a las 10.47.02 a.m..png

1 Solution

Accepted Solutions

Re: Colour of background depending of cell value

Hi Gerd,

Great!! Just noticed, could you add equal sign near 45000 (i.e <=45000).. i missed to add that in the above expression.

IF(Avg([Rec_pesobrutot])>=43000 and Avg([Rec_pesobrutot])<=45000, lightblue(), if(avg([Rec_pesobrutot])>45000 and avg([Rec_pesobrutot])<=47000, lightgreen()))


Thanks.

4 Replies

Re: Colour of background depending of cell value

@Hi Gerd,

IF(Avg([Rec_pesobrutot])>=43000 and Avg([Rec_pesobrutot])<45000, lightblue(), if(avg([Rec_pesobrutot])>45000 and avg([Rec_pesobrutot])<=47000, lightgreen()))

Try the above expression in background color property of the expression.

pastedImage_0.png

Note: you can also use RGB(120,120,120) like wise. Change the values according to the need.

Not applicable

Re: Colour of background depending of cell value

Hi Gerd,

Not sure if this would help going forward, but have you tried the Colourmax wizard…is a very user friendly way to achieve colour formats.

Good luck,

Jason.Colour.jpg

Not applicable

Re: Colour of background depending of cell value

Thank very much to both,

i used IF(Avg([Rec_pesobrutot])>=43000 and Avg([Rec_pesobrutot])<45000, lightblue(), if(avg([Rec_pesobrutot])>45000 and avg([Rec_pesobrutot])<=47000, lightgreen()))

and it works fine for me, i can't use Jason answer because, in my version of qlik sense i don't have this tool bar in the top of the software.

King Regards!

Gerd Neumann

Re: Colour of background depending of cell value

Hi Gerd,

Great!! Just noticed, could you add equal sign near 45000 (i.e <=45000).. i missed to add that in the above expression.

IF(Avg([Rec_pesobrutot])>=43000 and Avg([Rec_pesobrutot])<=45000, lightblue(), if(avg([Rec_pesobrutot])>45000 and avg([Rec_pesobrutot])<=47000, lightgreen()))


Thanks.