Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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
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.

Master
Master

Hey Meher,

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

Not applicable

Hi Krishnamoorthy ,

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

thanks

meher

Not applicable

Thanks Johannes

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

thanks a lot

Meher

Master
Master

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

Not applicable

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

Master
Master

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

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

Master
Master

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