Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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())
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.
I am using Qlik Sense
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
I tried this:
if(avg(total total_rvu)-avg(total_rvu))>0,green(),red())
But I didn't get the desired results
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.
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
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) ?
Have you tried using the same formula and replacing Green with '▲' and red with '▼' for the expression?
I have, that did not work, it's saying that ▼ is not a valid function