# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Not applicable

## how to set the min and max values of a guage chart in percentages

Namste,

I want to create a guage chart, with 3 segments , which shows the efficiency

100% to 99%

99% to 98%

98% to 97%

i am getting the error:  Bad min or max value in guage

6 Replies
Valued Contributor

## Re: how to set the min and max values of a guage chart in percentages

Hi Ganesh, you have to put the percentages like this (1, 0.98 and 0.97) Maybe you're putting those with coma instead of period?

Hope it helps,

Andrés

Not applicable

## Re: how to set the min and max values of a guage chart in percentages

some improvement to my question,

here i have set the values in grange from

97% to 98%

98% to 99%

99% to 100%

but i want the needle to start from max value to min value since it is a efficiency guage.

I hope , i explained my question properly

i want the needle to start from higher percentage that 100 to 99  to down ,as it is eeficiency

New Contributor II

## Re: how to set the min and max values of a guage chart in percentages

Hi Ganesh,

Are you sure that the values for efficiency are within the range of 0% and 100%?

When I am generating this error it is as a result of the values not being within that range or if my min value is greater than my max value.

For Gauge settings, you'll want:

Min: 0.97

Max: 1

I suggest checking the calculation in a straight table to see what the answers are, and moving from there.

Hope that helps

Paul

Not applicable

## Re: how to set the min and max values of a guage chart in percentages

Hi Andres

at the moment, my guage chart is showing needle in clockwise direction from min to low 97% to  100%

I want needle of guage chart in anti clockwise direction i.e from 100 % to 97%

Not applicable

## Re: how to set the min and max values of a guage chart in percentages

Hi Paul,

yes, i have taken the percentage of efficiency i want is from 97% to 100% as shown above in screenshot.

I want the needle to be moving in anti-clockwise direction or

i want to know, is there any way to get  the guage chart values from 100% to 97%

i mean, 100 in place of 97 and vice versa in the above image.

i hope, i explained my problem

MVP

## Re: how to set the min and max values of a guage chart in percentages

You cannot do this directly, so you have to work around the limitation. First negate the expression so that an increase is a decrease in your original expression: