Is it possible to add a traffic light indicator in a pivot table like in Qlikview?

[#1]

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.

[Gysbert_Wassenaar]

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.

[#3]

Thank you very much for your help! It works very well, I don´t care about the circle jaja.

Bye!

[Anonymous]

Do you have an actual example of the expression used?

[#5]

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

[kavita25]

How to add circles along with the expression??

[vinay_hg]

just check ASCII keys in google, you will get value for all the ASCII symbols. you can use any sysmbol you want in that

[kavita25]

I want to use it with the conditional expression.

If u know, Please share the expression

Regards,

kavita

[apthansh]

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 ?

[apthansh]

do you have any sample chart ?