topic Gauge Color in QlikView

Gauge Color

Wed, 04 Jun 2014 18:22:06 GMT

Is it possible to change the color of a gauge embedded in a Table when a certain condition is satisfied?

As in the image below, i would like to make the Gauge color to red if [Change] is negative.

I have this formula inside gauge settings for color but it doesn't seem to work. Any help is appreciated. I also attached the sample app.

Calculated Color (inside Gauge Settings):
if ((Sum({$<[Report Date]={'3/31/2014'}>}[Equity Price]) - Sum({$<[Report Date]={'12/31/2013'}>}[Equity Price]))<0,rgb(255,0,0),rgb(0,0,255))

Re: Gauge Color

jolivares — Wed, 04 Jun 2014 18:38:00 GMT

I think that is no possible because the values of each segment apply to all.

But in QV you never now... wait for a genius...

Re: Gauge Color

maxgro — Wed, 04 Jun 2014 18:40:33 GMT

I suppose you can't change the color of the bar in a table

Re: Gauge Color

jerem1234 — Wed, 04 Jun 2014 18:50:11 GMT

Just to add to the consensus, it is not possible. You can change the color of all the bars, but not based on the dimensions of the chart. All the bars either turn blue or all red, can't have them dynamically change based on their sum unfortunately.

Hope this helps!

Re: Gauge Color

Thu, 05 Jun 2014 13:57:48 GMT

Thanks all for the clarification.