topic Re: Cell background colour based on cell's value in QlikView

Cell background colour based on cell's value

Mon, 06 Jan 2014 16:55:42 GMT

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.

Re: Cell background colour based on cell's value

Nicole-Smith — Mon, 06 Jan 2014 17:00:26 GMT

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:

Re: Cell background colour based on cell's value

sureshbaabu — Mon, 06 Jan 2014 17:21:54 GMT

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

Re: Cell background colour based on cell's value

nirav_bhimani — Mon, 06 Jan 2014 17:22:50 GMT

Hi,

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

Kindly find the attached file.

Regards,

Nirav Bhimani

Re: Cell background colour based on cell's value

rwunderlich — Mon, 06 Jan 2014 23:58:21 GMT

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

Re: Cell background colour based on cell's value

Tue, 07 Jan 2014 05:26:26 GMT

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

Re: Cell background colour based on cell's value

Thu, 21 Apr 2016 05:20:22 GMT

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.

is there any way to achieve this ?

Re: Cell background colour based on cell's value

Shubham_Deshmukh — Fri, 04 May 2018 13:46:50 GMT

failed to load