topic Gauge chart fill to value % segments setup in QlikView

Gauge chart fill to value % segments setup

Anonymous — Wed, 10 May 2017 19:30:14 GMT

Hi,

I need some help with my gauge chart.

it wont fill to value with green (-%) or red (+%)

Expression:

=if(sum({<År={"$(=max(År))"}>}kWh)/sum({<År={"$(=min(År))"}>}kWh)>=0.05, Green(), LightRed())

Gauge settings Min and max value, lower bound. What to input?

sunny_talwar — Wed, 10 May 2017 19:35:47 GMT

May be try to enter 0.5 here for Segment 1 and 1 for segment 2

Anonymous — Wed, 10 May 2017 19:44:34 GMT

Hi Sunny,

Thanks for reply !

sunny_talwar — Wed, 10 May 2017 19:47:27 GMT

Keep the color non-calculated... green() for segment 1 and Lightred() for segment 2

Anonymous — Wed, 10 May 2017 20:05:29 GMT

sunny_talwar — Thu, 11 May 2017 08:22:08 GMT

The percentage can be negative as well? May be do -1 for min... I am not sure...