color change to text in a cell

[Anonymous]

Hello,

Duda 1:
I would like to know if you can change the text color to a cell in a table depending on the value of this in QlikView , for example:
There are 3 possibilities: <= 5 ( text color is red)

>= 5 ( text color is green)

and if it is between 96 and 104 ( the color is blue )

As you could color the text depending on the 3 possibilities mentioned above

greetings and thank you very much

Luis Espinoza

[sunny_talwar]

You can surely do that, which chart are you using?

[satishkurra]

Hi

Use below

Go to expressions , click the + icon in expressions, go to text color and specify below

If ( expression =5, red(),

If(expression =10, green(),

If(expression >=56 and <=99, yellow(),

Grey())))

[satishkurra]

Accurate expression:

If (expression <=5, red(),

If(expression >5, green(),

If(expression >=96 and <=104, blue(),

Grey())))

[clondono]

If you are using a straight table or a pivot table, you can use "Visual Cues".  Go to the table properties and select the visual cues tab, then you can select the cell background or the text color/format based on cell value.

Regards,

Carlos

[Chanty4u]

hi u can give exprsion lik below

If (Expression <=5, Red(),If(expression >5, Green(),If(Expression >=96 and <=104, Blue(),

Grey())))