Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Negative value with different Color in Gauge Chart

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.

3 Replies
adamdavi3s
Honored Contributor

Re: Negative value with different Color in Gauge Chart

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
Contributor II

Re: Negative value with different Color in Gauge Chart

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
Honored Contributor II

Re: Negative value with different Color in Gauge Chart

attached sample might be helpful