Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can surely do that, which chart are you using?
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())))
Accurate expression:
If (expression <=5, red(),
If(expression >5, green(),
If(expression >=96 and <=104, blue(),
Grey())))
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
hi u can give exprsion lik below
If (Expression <=5, Red(),If(expression >5, Green(),If(Expression >=96 and <=104, Blue(),
Grey())))