Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

marius_larsen
Contributor

Expressions Defenition Gauge Chart

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.

Gauge.PNG


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)

definisjon.PNG

__________________________________________________________________________________________

some more screenshots:

Presentation.PNG

Segment 1:

Segment1.PNG

2 Replies
Employee
Employee

Re: Expressions Defenition Gauge Chart

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.

awhitfield
Esteemed Contributor

Re: Expressions Defenition Gauge Chart

The attached may help

Community Browser