Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone, I have been trying to add a traffic light indicator in Qliksense, following the tutorial of Qlikview, but it wasn`t possible so far. I know that the conditional color of the measure works similar to the traffic light but the client has the power.
I attached an image to explain me better.
Thank you very much for your help.
Circles I don't know about, but if you can live with squares then you can create a Measure with an expression like ='██' using two alt+219 ascii characters and add a Text Color expression to the measure with an expression just like in Qlikview.
Thank you very much for your help! It works very well, I don´t care about the circle jaja.
Bye!
Do you have an actual example of the expression used?
Hello Ed, here is the expression
if(Sum([Real Cost])/Sum([Budget])>=1,lightred(),if(Sum([Real Cost])/Sum([Budget])>=0.7,yellow(),if(Sum([ Real Cost])/Sum([Budget])<=0.69,lightgreen())))
Sorry for the delay
How to add circles along with the expression??
just check ASCII keys in google, you will get value for all the ASCII symbols. you can use any sysmbol you want in that
I want to use it with the conditional expression.
If u know, Please share the expression
Regards,
kavita
Hey...
I am trying to get this done but not going smooth.So far this is I am doing and in Text Color expression I have the below expression...
If(ATStatus2=0,Blue(),
If(ATStatus2=1,Green(),
If(ATStatus2=2,yellow(),
If(ATStatus2=3,red(),
If(ATStatus2=4,white())))))
am I missing anything here ?
do you have any sample chart ?