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.
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
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
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...
am I missing anything here ?