Coloring table cell with IF statement

[#1]

I have a similar table in Qlik Sense:

I have a column for:

Physician

AVG RVU (productivity number)

Varience

What I would like to do is color the cell red or  green depending on the variance being a positive or negative change. Coloring the entire cell or just the arrow will work.

The expression for the varience is:

avg(total total_rvu)-avg(total_rvu)

Thank you in advance.

[chancekbarkley · Accepted solution]

Nathan, i just tried it and this worked for me.

Use this in your Expression:

if((avg(total total_rvu)-avg(total_rvu))>0,'▲','▼')

Use this for your background color:

if((avg(total total_rvu)-avg(total_rvu))>0,Green(),Red())

[#3]

Hi Nathan,

Have you tried for the main expression

if((avg(total total_rvu)-avg(total_rvu))>0,'qmem://<bundled>/BuiltIn/arrow_n.png','qmem://<bundled>/BuiltIn/arrow_s.png')

But you must select (from Expressions tab) Display options Image (see picture)

And keep

if((avg(total total_rvu)-avg(total_rvu))>0,Green(),Red())

As the colour format?

Fingers crossed, we'll all get there!

Regards,

Jason.

[#4]

Thanks, this did work!