topic Re: Set background color for multiple fields at once in QlikView

Set background color for multiple fields at once

Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to change the background color of multiple fields at once automatically?
I've got the table below and would like to color all the columns like the 10:00-column. Does one have to do that manually for each field?

Re: Set background color for multiple fields at once

Chanty4u — Tue, 05 Apr 2016 16:22:45 GMT

did u try custom format cell?

Re: Set background color for multiple fields at once

Chanty4u — Tue, 05 Apr 2016 16:25:49 GMT

chk dis...>

view tab ,,> select design grid -->select table----?rightclik--->custom format cell

lik below

Re: Set background color for multiple fields at once

Tue, 05 Apr 2016 21:41:28 GMT

I tried that, but apparently the whole column get's colored, and not just the cells with value 1. I'm still be interested in that approach though.

I managed it through the 'Visual Cues'-Tab for now, where I specified the bgColor for values >=1 as blue, and those <=0 as white:

Re: Set background color for multiple fields at once

clondono — Tue, 05 Apr 2016 22:16:10 GMT

Open the table properties and go to the expressions tab. Select the expression and click in the plus "+" sign. Highlight "background color" and in the definition enter the condition for the color for example:

=if("your condition here" > 0, Green(), White())

Regards,

Carlos

Re: Set background color for multiple fields at once

Tue, 05 Apr 2016 22:39:04 GMT

Hey Carlos,

thanks for your reply.

But the question at hand was if it was possible to change the background of cells with value 1 for multiple columns at once.

My current problem is a table generated by a generic load and therefore potentially with a lot of dimensions. Right now it's 'only' 24 columns, but with a growing number of columns it would be time-consuming to set the background manually.

Re: Set background color for multiple fields at once

clondono — Tue, 05 Apr 2016 22:50:59 GMT

what kind of chart are you using? can you post a sample qvw file?