How can I color negative values and positive values in QlikView?

[khadraouihiba02]

Hello,

How can I color negative values red and positive values green in QlikView?

  

[saso70]

Hi , click on + symbol next to expression 

[saso70]

expression will be something If([Column Name]<0, Red(), Green())

[khadraouihiba02]

@saso70 I do this but it doesn't work

 

[khadraouihiba02]

@saso70  the histogram change to red not the value

 

  

[p_verkooijen]

Hi @khadraouihiba02 

SUM([Columnname]) will not work as it is not a valid field.

1 If you reference the column use IF([EVOLUTION]<0, LightRed(), Green())

2 Otherwise use the Expression Definition

IF((N-(N_1)/(N_1)) < 0, LightRed(), Green())

3rd option is to use the Visual Queues (Couleurs) 
* only available for Straight table and Pivot

[khadraouihiba02]

Hi, @p_verkooijen iit doesn't work

  

[p_verkooijen]

Hi @khadraouihiba02 

Quite hard to read your setup.
Try to switch to a straight table when creating measures to see the outcome instead of trying to build a visualization where you cannot see any data. 

U have 2 measures in place here, I guess the first Objectif creates the bars? 

The outcome EVOLUTION will not be more than 1? 

Also, you should always use aggregation functions in a measure definition, use SUM((N-(N_1)/(N_1))*100) 

Can you share a QlikView document with some anonymous data?

[khadraouihiba02]

@p_verkooijen  Objectif is for the indicators

[anat]

you can use expression text color