Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

guage charts

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

9 Replies
nagaiank
Specialist III
Specialist III

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

You can assign minimum value of segments accordingly.

Hope this helps.

Anonymous
Not applicable
Author

Hey Meher,

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

Not applicable
Author

Hi Krishnamoorthy ,

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

thanks

meher

Not applicable
Author

Thanks Johannes

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

thanks a lot

Meher

Anonymous
Not applicable
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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..

Not applicable
Author

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

Anonymous
Not applicable
Author

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