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

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

Mon, 14 Sep 2015 13:02:10 GMT

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.

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

Gysbert_Wassenaar — Tue, 15 Sep 2015 10:07:30 GMT

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.

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

Tue, 15 Sep 2015 12:18:39 GMT

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

Bye!

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

Anonymous — Fri, 26 Feb 2016 17:14:24 GMT

Do you have an actual example of the expression used?

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

Tue, 08 Mar 2016 12:39:27 GMT

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

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

kavita25 — Wed, 07 Sep 2016 10:30:55 GMT

How to add circles along with the expression??

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

vinay_hg — Wed, 07 Sep 2016 10:36:39 GMT

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

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

kavita25 — Thu, 08 Sep 2016 06:44:35 GMT

I want to use it with the conditional expression.

If u know, Please share the expression

Regards,

kavita

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

apthansh — Mon, 06 Mar 2017 18:45:59 GMT

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 ?

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

apthansh — Mon, 06 Mar 2017 21:33:57 GMT

do you have any sample chart ?

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

apthansh — Mon, 06 Mar 2017 21:35:01 GMT

Traffic light indicator in Qliksense

Please see if you can help me.Thank you.

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

Gysbert_Wassenaar — Tue, 07 Mar 2017 18:01:03 GMT

Include the two characters in single quotes so that Qlik Sense knows it's a text string and not non-existing a field name.

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

akpofureenughwu — Tue, 11 Apr 2017 04:07:21 GMT

stalwar1‌ gwassenaar‌

Hello sir, Please throw more like how this can be done? How one can insert any ascii character?

Regards

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

vvvvvvizard — Tue, 02 May 2017 04:23:12 GMT

Char(64)

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

nikhilgarg — Wed, 24 Oct 2018 08:37:40 GMT

Just to correct, it is Alt+254 that we need to use

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

apthansh — Fri, 02 Nov 2018 02:20:44 GMT

Thank you.That worked for me.