topic Re: guage charts in QlikView

guage charts

Sat, 11 Jun 2011 23:03:11 GMT

Hello Experts

I have a query to clarify regarding mini guage charts

my requirement is to make a personal chart on my expenses and earning ...

I'm trying to use a traffic guage and if my expenses are greater than earnings my guage have to turn into red

if my expenses are equal to earnings my guage have to turn into blue and

if my expenses are less than earnings my guage have to turn into green

is this possible ??? itried it but in segments it asks for a value then ow can i do it ???

example my data is like this

expenses earnings guage color

30,750 25,687 red

18,600 18,600 blue

22,600 30,920 green

is there any way to do it ???

thanks to u all

Meher

guage charts

nagaiank — Sat, 11 Jun 2011 23:17:11 GMT

You may use Earnings/Expenses or (Earinings - Expenses) as value.

You can assign minimum value of segments accordingly.

Hope this helps.

Re: guage charts

Anonymous — Sat, 11 Jun 2011 23:30:43 GMT

Hey Meher,

Here's one way of doing it. You can change the values in the input box for testing.

guage charts

Sun, 12 Jun 2011 00:37:36 GMT

Hi Krishnamoorthy ,

thats a nice idea but it won't works for me because i cant assign values for segments ...

thanks

meher

guage charts

Sun, 12 Jun 2011 00:41:28 GMT

Thanks Johannes

May be it works & i think i can use predefined values instead of giving values thru input box ...

thanks a lot

Meher

guage charts

Anonymous — Sun, 12 Jun 2011 00:43:10 GMT

Sure, the input box is merely for testing and showing that it works. Otherwise you can use Sum(Expenses) etc. instead.

guage charts

Mon, 13 Jun 2011 20:14:23 GMT

Hi Johannes

I tried to make it work as a mini chart but it fail's.

I'm trying to compare budget vs sales but its not working perfectly for me I mean the guage is changing colors between only orange & Green & its showing both Orange & Green for Sales<< budget....

I’m using this expression

If((Sales2009<<Budget2009),(if(Sales2009=Budget2009,-1,0)),1)

And in gauge settings I’m using -1 & 1 as min & max values of gauge and trying for 3 segments as -1to0 for Red , 0 for Orange & 0.1 to 1 for green

Any idea to sort this out

thanks

Meher

guage charts

Anonymous — Mon, 13 Jun 2011 23:17:40 GMT

Hi Meher,

You might want to try using Sum(Sales2009) etc. instead of just the fieldnames since I assume that you have more than one value for each of the fields.

If((Sum(Sales2009)<=Sum(Budget2009)),(if(Sum(Sales2009)=Sum(Budget2009),0,-1)),1)

something like that..

guage charts

Mon, 13 Jun 2011 23:24:00 GMT

hi Johannes ,

i need it for each & every row in a mini chart i'll try it and i'll let you know

thanks a lot

meher

guage charts

Anonymous — Mon, 13 Jun 2011 23:25:21 GMT

Oh, ok. In that case please send in a copy of the document if you can't figure it out.