Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
@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.
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.
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
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.