Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
angel2605
Contributor III
Contributor III

color change to text in a cell

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

5 Replies
sunny_talwar

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

satishkurra
Specialist II
Specialist II

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
Specialist II
Specialist II

Accurate expression:

If (expression <=5, red(),

If(expression >5, green(),

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

Grey())))

clondono
Creator III
Creator III

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.1.png

Regards,

Carlos

Chanty4u
MVP
MVP

hi u can give exprsion lik below

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

Grey())))