Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tamilarasu
Champion
Champion

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.

View solution in original post

4 Replies
tamilarasu
Champion
Champion

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

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
Author

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

tamilarasu
Champion
Champion

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.