Discussion Board for collaboration related to QlikView App Development.
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 abovegreetings and thank you very much
You can surely do that, which chart are you using?
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(),
If (expression <=5, red(),
If(expression >5, green(),
If(expression >=96 and <=104, blue(),
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.
hi u can give exprsion lik below
If (Expression <=5, Red(),If(expression >5, Green(),If(Expression >=96 and <=104, Blue(),