Discussion board where members can get started with Qlik Sense.
I have a gauge chart with expression so same I have to show in table box with bg color
so how can I use?
expression I have placed in variable
vMyExpression =This expression is big so I want to use variable in bg colour
logic: 0-80% red, 80%-90% amber >90% green
Go to Solution.
variable can not hold multiple values.If the expression is big you can perform the calculations at script level.
with your expression you can try something like below.
=if(vMyExpression>90,RGB(0,204,0),if(vMyExpression>=80 and vMyExpression<=90,RGB(255,255,0),if(vMyExpression<80,RGB(255,0,0))))
Following may help
Relative Text Color expression
May be your vMyExpression evaluation is going wrong.
thanks its working now