topic Linear Gauge Color in Straight table in QlikView

Linear Gauge Color in Straight table

Fri, 03 Oct 2014 11:10:16 GMT

Hi All,

I have a linear gauge in a straight table and the requirement is:

have a single segment
change the segment color based on an expression

The same expression is used in a text field and the colours work well but for the gauge chart the segments show only one color for each line.

The Expression is somewhat like:

=if(Sum(PASS)/(Sum(PASS)+Sum(FAIL)) > 0.85, RGB(0,128,0), RGB(255,0,0))

Please suggest if it's even possible to achieve this?

Re: Linear Gauge Color in Straight table

Fri, 03 Oct 2014 11:18:40 GMT

color not recalculated for your dimention (like using $() ).

just use background color of table cell(expression) and transperent gauge

Re: Linear Gauge Color in Straight table

jonathandienst — Fri, 03 Oct 2014 11:23:27 GMT

Not sure what you are trying to achieve. Each segment can have a separate colour, but with a single segment, the bar can only display one colour.

Jonathan

Re: Linear Gauge Color in Straight table

Gysbert_Wassenaar — Fri, 03 Oct 2014 11:23:52 GMT

See attached qvw for another option.

Re: Linear Gauge Color in Straight table

Fri, 03 Oct 2014 11:25:20 GMT

LOL nice try =)))

Re: Linear Gauge Color in Straight table

Fri, 03 Oct 2014 12:41:11 GMT

Thanks Gysbert,

I am trying to achieve the same with a Gauge Chart but I guess the color calculation does not work in the same way as it does not allow calculating colors based on the dimension but the color calculation does not consider the dimension.

@ Jonathan: I am only trying to get a single color but based on the expression change the color for the gauge. Please refer to the attached image, the text field shows green where the % is greater than 85 else red. I want the same for the Gauge color:

Re: Linear Gauge Color in Straight table

Fri, 03 Oct 2014 13:19:39 GMT

Sem,

I guess your solution works as the workaround and I can live with that

Re: Linear Gauge Color in Straight table

Fri, 03 Oct 2014 13:54:10 GMT

glad to help

Re: Linear Gauge Color in Straight table

b_garside — Wed, 13 Jul 2016 17:08:48 GMT

I've been trying to do the exact same thing. Not sure I understand "just use background color of table cell(expression) and transparent gauge" any ideas how making the background transparent will help?

Wish there was a sample of this

Re: Linear Gauge Color in Straight table

jim_chan — Mon, 08 Aug 2016 16:26:39 GMT

hi there, where can i find this icon? '█' ???

Rgds

Jim

Re: Linear Gauge Color in Straight table

b_garside — Mon, 08 Aug 2016 16:50:34 GMT

You can paste it as is OR use ascii code =Chr(219)

Alt+219 = █

http://www.asciitable.com/