Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

percentage show in speedometer

Hi ,

How can I display percentage/value in speedometer. Currently for calulating percentage of two fields I added a expression.

Example:-

Offer Quoted

Offer accepted

Fomula i used in expression is Sum(([Offer accepted]) *100)/Sum([Offer Quoted]). I want to see the percentage value display in speedometer. Can someone help?

Thanks

Tags (1)
8 Replies
nilesh_gangurde
Valued Contributor

Re: percentage show in speedometer

hiii,

Create new chart, select gauze chart and add expression to calculate %.

-Nilesh

mov
Esteemed Contributor III

Re: percentage show in speedometer

First, you can remove *100 in your expression.

Next, in presentation tab, set Min=0 and Max=1 (if it can go above 100%, you can use a larger limit, e.g.1.5 for 150%).

On the Number tab, use integer or "fixed to", and chaeck "Show in %".

Regards,

Michael

Not applicable

Re: percentage show in speedometer

Michael,

Will that work for negative numbers?

mov
Esteemed Contributor III

Re: percentage show in speedometer

If you can have negative %, set Min to a negative value.  E.g. if Min=-1 and Max=1, you get range from -100% to 100%

Not applicable

Re: percentage show in speedometer

Ok. I set min of -10 and max of 50 in Presentation and I define segement bound as

<0 = Orange

0-5 = green

5-10 = yellow

>10 = Red

Now for example Sum(Offer Quoted) = 1500

                            Sum(Offer Accepted) = 2500

I used a formula Sum([Offer Quoted])/ Sum([Offer Accepted]) where my value in percentage will be 60% but the chart displaying incorrect color. Am I doing wrong in setting bound for each segment?

mov
Esteemed Contributor III

Re: percentage show in speedometer

Well, that means that you expect range from -1000% to 5000%.  Colors:

from -1000% to 0 - orange

from 0 to 500% - green

from 500% to 1000% - yellow

from 1000% to 5000% - red

Is it what you want?  The 60% result will be in green.

Not applicable

Re: percentage show in speedometer

Thanks Michael!!

I figured out the issue. Working...yeeee

Not applicable

Re: percentage show in speedometer

Do anyone aware of defining the specific colors to the pie chart for the calculated dimesion?

Community Browser