Discussion Board for collaboration on QlikView Layout & Visualizations.
How can I display percentage/value in speedometer. Currently for calulating percentage of two fields I added a expression.
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?
Create new chart, select gauze chart and add expression to calculate %.
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 %".
Will that work for negative numbers?
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%
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?
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.
I figured out the issue. Working...yeeee
Do anyone aware of defining the specific colors to the pie chart for the calculated dimesion?