Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

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.

Indicator.png

15 Replies

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

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.


talk is cheap, supply exceeds demand
Not applicable

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

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

Bye!

Traffic light.png

escarber
New Contributor

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

Do you have an actual example of the expression used?

Not applicable

Re: Is it possible to add a traffic light indicator in a pivot table 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

kavita25
Valued Contributor

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

How to add circles along with the expression??

vinay_hg
Contributor II

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

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
Valued Contributor

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

I want to use it with the conditional expression.

If u know, Please share the expression

Regards,

kavita

apthansh
New Contributor III

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

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 ?

Capture.PNG

apthansh
New Contributor III

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

do you have any sample chart ?