Linear Guage Question

Wed, 10 Apr 2013 13:55:14 GMT

Hi Folks

I'm trying to create a linear guage where the guage is filled to value but also includes a colour segment after the fill to value, much the same as this image:

I had assumed that this would require setting the lower limit of segment 2 to be variable, so that the lower limit is actually the value of the column itself. However, when I try to addin either Column(4) or the actual expression Sum(a)/(Sum(a)+Sum(b)) into the lower segment it doesn't work.

If I use Column(4) then the lowe limit is set to zero and I get a solid red bar,

If I use the expression then it works but it sets the lower limit the same on every linear chart in the table, so it would appear that it is executing this calculation over the total dataset, not the row in the table.

Any ideas?

Nigel.

Re: Linear Guage Question

Gysbert_Wassenaar — Wed, 10 Apr 2013 17:51:53 GMT

You can try setting the background color of the gauge to red. I've used something similar here in combination with a white fill color to create a 'negative' valued bar.

Re: Linear Guage Question

Thu, 11 Apr 2013 08:57:06 GMT

Hi Gysbert

Not perfect, but good enough to get me out of trouble.

Thanks for your help.

Nigel.

topic Re: Linear Guage Question in QlikView

Linear Guage Question

Re: Linear Guage Question

Re: Linear Guage Question