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.

[#2]

Correct me if i'm wrong. You are trying to do this in Qlikview? if so.

If its a straight table u use visual que's & use the color expression there, also u can try by giving color expression in the dimension or KPI pivot's. like in the image below.

Thanks

Brad.

[#3]

I am using Qlik Sense

[Anonymous]

Are you trying to do this in Qlik Sense?

If so,you can use a straight table -> data -> background color, you can put the expression

if(varience>0, green(),red())

Best Regards

[#5]

I tried this:

if(avg(total total_rvu)-avg(total_rvu))>0,green(),red())

But I didn't get the desired results

[#6]

Hi Nathan,

Your formula is nearly there, but think it is a bracket issue, please try;

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

Regards,

Jason.

[chancekbarkley]

Nathan,

It looks like you may have a misplaced parenthesis that is terminating the if statement prematurely.  Try this:

if(avg(total total_rvu)-avg(total_rvu)>0,green(),red())

or this:

if((avg(total total_rvu)-avg(total_rvu))>0,green(),red())

-cb

[#8]

I have it working, sort of.  I used if(((avg(total total_rvu)-avg(total_rvu)))>0,green(),red()) in the background color expression and in the normal expression.

Is there a way to display ▼/ ▲ instead of the RGB(128,0,0) ?

[chancekbarkley]

Have you tried using the same formula and replacing Green with '▲' and red with '▼' for the expression?

[#10]

I have, that did not work, it's saying that ▼ is not a valid function