Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cell background colour based on cell's value

I have a Table Box object and one of the columns (Status) will always contain a string of either 'IN' or 'OUT'. I have gone into Custom Cell Formatting and attempted to change the background to a function like so:

IF([Status]='IN', LightBlue(), LightGreen())

But it only equates to true if ([Status]='IN' after selection, but I would like the fields to be colour coded without having to select anything. I thought fieldValue() might help me but wasn't sure how to use it.

Something like

IF(THISVALUE='IN', LightBlue(), LightGreen())

??

Thanks.

1 Solution

Accepted Solutions
Nicole-Smith

You can't do this on a table box.  You need to use a pivot or straight table, and then you can write an expression using the Background color on the dimension or expression:

View solution in original post

7 Replies
Nicole-Smith

You can't do this on a table box.  You need to use a pivot or straight table, and then you can write an expression using the Background color on the dimension or expression:

sureshbaabu
Creator III
Creator III

That's right.. it's not possible in Table Box. You can achieve thro pivot or straight table views.

FYI... you can even use images in place of plain colors


Thanks

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Its not possible through Table box, You can use straight table & Hide your expression,

Kindly find the attached file.

Regards,

Nirav Bhimani

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

There is no need to create a hidden expression. When you have a straight table with Dimensions only, just uncheck "Suppress Zero Values" on the Presentation Pane.

-Rob

http://masterssummit.com

http://robwunderlich.com

Not applicable
Author

Hi George,

You can directly go to 'Chart Properties'  inside that 'Visual Cues', there you can directly set your range for Cell Background and Text colour also.

Thanks,

Shiven..

Not applicable
Author

Hi Nicole, Thanks for the solution, I have a slightly different requirement here. I have to color the cell in different shades between two colors (say red and blue) based on the cell value like in the below image.

Color.JPG

is there any way to achieve this ?

Shubham_Deshmukh
Specialist
Specialist

failed to load