topic Re: Change color value - simple table in QlikView

Change color value - simple table

Fri, 14 Aug 2015 12:29:42 GMT

How can I change the color of values column 'Marge * Qté' in blue : ex 256.77€ in blue

Thx in advance

Anonymous — Fri, 14 Aug 2015 12:31:33 GMT

there are several Options:

- tab visual clues you can define colores depending from values

- tab Expression, click "+" from your Expression , there you can define Colors as well

rubenmarin — Fri, 14 Aug 2015 12:34:13 GMT

Hi, in the Expression tab you can set an exprssion to set the color:

It can be based on conditions and using RGB() or any other color function, ie:

If([ExpressionName]>0, RGB(0,128,0), Red())

Anonymous — Fri, 14 Aug 2015 12:34:35 GMT

for simple table there is only one option

you can achieve by this way:

- define "design grid" (tab Menu)

- Position your table and there your expression
AND right mouse click on "Custom Format cell"

- select cell

- goto Background Color and enter Color you want

- apply and close

- complet Expression is colored

Fri, 14 Aug 2015 12:35:24 GMT

How can i ? What to put in Definition tab?

thx in advance

Anonymous — Fri, 14 Aug 2015 12:38:57 GMT

you can enter rgb code or a variable which holds rgb code

for instance =rgb(255,0,0) for red

or you use the build in Colors like White(), red() etc.

rgb Colors can be checked if you goto Color Definition, if you select requried Color you can read rgb values

Fri, 14 Aug 2015 12:40:46 GMT

Thank U ... That's what I want

Stanley

Fri, 14 Aug 2015 12:41:48 GMT

Thx U