topic Color in Gauge Chart in QlikView

Color in Gauge Chart

Tue, 17 Dec 2013 12:45:14 GMT

I am trying to show a bar in a straight table which has its color depending on a value

e.g. red if below 1 and green if above it

I have adjusted the gauge setting to:

the bar however always shows up in green? In the first 2 rows I wanted it to be red().

stabben23 — Tue, 17 Dec 2013 13:10:50 GMT

Hi,

use sum in our expression, now it will count FinanzenA.Wert and it always 1.

like this if(sum(FinanzenA.Wert <1,red(),green()))

and maybe you shold use aggr on your dimension, like if(aggr(sum(FinanzenA.Wert),FinanzenA.Bezeichner)<1........

//Staffan

Tue, 17 Dec 2013 13:22:12 GMT

the formula you gave looks to have a syntax problem

I used if (sum(FinanzenA.Wert) < 1, red(), green())

but this does not change the color either

Juerg

stabben23 — Tue, 17 Dec 2013 13:29:07 GMT

Hi,

use a aggr function if(sum(aggr(sum(FinanzenA.Wert),FinanzenA.Bezeichner)<1,red(),green()))

//Staffan

Tue, 17 Dec 2013 13:44:22 GMT

Thanks Staffan for your quick replies - however your formula still has a syntax problem and my changes to make it work have so far been of no success

Juerg

P.S. just saw that the color adjust correctly if only a single row is selected ...