topic Re: Negative value with different Color in Gauge Chart in QlikView

Negative value with different Color in Gauge Chart

Wed, 25 Nov 2020 16:16:04 GMT

HI All,

Trying to display Bar chart in a straight table.

Is there any possibility to display positive value and negative value in the same side with different Colors.

adamdavi3s — Tue, 21 Mar 2017 10:21:51 GMT

yes using the background formula of the expression (click the + next to the expression on the expressions tab)

if(yourexpression <=0,lightred(),green())

or insert your own rgb colours in there

stephenedberkg — Tue, 21 Mar 2017 12:34:38 GMT

HI,

For the percentage values use this formula as background color

if(yourexpression <=0,red(),green())

for the linear gauge chart set the lower bound is -1 and lower bound color is red

upper bound is 0 and color is green

Frank_Hartmann — Tue, 21 Mar 2017 15:06:03 GMT

attached sample might be helpful