topic Expressions Defenition Gauge Chart in QlikView

Expressions Defenition Gauge Chart

Anonymous — Fri, 27 Feb 2015 14:53:19 GMT

Hi,

I've made a gauge chart that shows how much % electricity that is saved (oldest selected year vs latest selected year), but the color will not change as the percentage change.

Text in Chart: =num(sum({<År={"$(=max(År))"}>}kWh)/sum({<År={"$(=min(År))"}>}kWh)-1,'#.0%')

I need help with the definition of the expression (see picture)

__________________________________________________________________________________________

some more screenshots:

Segment 1:

Re: Expressions Defenition Gauge Chart

kji — Fri, 27 Feb 2015 15:03:49 GMT

I think you want to use the "Fill to Value" Indicator Mode,or you can just put your expression as the Lower Bound for your 2nd segment and keep the Indicator Mode "No Indicator" like you have.

Re: Expressions Defenition Gauge Chart

awhitfield — Fri, 27 Feb 2015 15:25:16 GMT

The attached may help