topic Re: Colour of background depending of cell value in QlikView

Colour of background depending of cell value

Tue, 17 Nov 2015 13:52:21 GMT

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

Re: Colour of background depending of cell value

tamilarasu — Tue, 17 Nov 2015 16:03:36 GMT

@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.

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

Re: Colour of background depending of cell value

Tue, 17 Nov 2015 16:11:00 GMT

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.

Re: Colour of background depending of cell value

Tue, 17 Nov 2015 17:39:00 GMT

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

tamilarasu — Tue, 17 Nov 2015 18:13:21 GMT

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.