topic Re: Gauge Chart in QlikView

Gauge Chart

Thu, 11 Oct 2012 19:52:46 GMT

Hi,

Can somebody temmg me how Gauge chart deals with -ve values and +ve values both at a time.

I have minimum as -100% and maximum value as 200%.

So i wil put -1 as min and max as 2. Now i want to set lower bount something , So that i wil get red(<75%),yellow(>75 and <95), and green(>95).

Not able to set lower bounds with -ve value percentages. If possible can somebody help me out in giving any sample file illustrating the example with gauge settings.

Thanks in Advance

Suneela

Re: Gauge Chart

MayilVahanan — Thu, 11 Oct 2012 19:58:09 GMT

Do you want something like attached??

Re: Gauge Chart

Thu, 11 Oct 2012 20:06:55 GMT

In the attached app you given Min as -100 and Max as 300 . But I want to give as -1 and 3 respectively. Now the lower bound showing is my concirn as decimals so that it can give me in percentages.

I have the values as -0.30,-0.50,-1.00,0.75,0.85 etc. So the lower limit in this case is -0.5 and upper limit is 1 as I have upto nearly 0.95 value. So based on this lower bound and upper bound setting is not working.

Re: Gauge Chart

Thu, 11 Oct 2012 20:08:27 GMT

In the attached app you given Min as -100 and Max as 300 . But I want to give as -1 and 3 respectively. Now the lower bound showing is my concirn as decimals so that it can give me in percentages.

Re: Gauge Chart

Thu, 11 Oct 2012 20:10:37 GMT

<.75 is red >.75 and <.95 yellow and >.95 red. I want to show this.....

Re: Gauge Chart

Thu, 11 Oct 2012 20:11:59 GMT

if I wil get -ve values it should fall under red category...Please suggest by example.

Re: Gauge Chart

MayilVahanan — Thu, 11 Oct 2012 20:14:18 GMT

Can you check now..

Its not satisfy your requirement.. Can you please post a sample file?

Edit:

Just now i saw your requirement..

Now check the attached file

Re: Gauge Chart

Thu, 11 Oct 2012 20:20:02 GMT

thanks .

Can you make one more segment for red which will fall below .75 and -ve. Yellow should be >.75 and green >.95.

Thanks in Advance.

Re: Gauge Chart

MayilVahanan — Thu, 11 Oct 2012 20:30:31 GMT

check the attached file..

hope that helps

Re: Gauge Chart

Thu, 11 Oct 2012 20:35:22 GMT

Thanks a lot.Now i got it.