topic background color for the header row in QlikView

background color for the header row

Fri, 25 Mar 2011 16:13:48 GMT

Hi,

I need to change color for the header rows.

How can I do that?

Thanks in advance.

background color for the header row

pljsoftware — Fri, 25 Mar 2011 17:08:33 GMT

if you can don't user the background property but use color indicator that are in sheet "Segnali visivi" is a sheet after Chart sheet.

I have the same problem and I think that is a bug.

background color for the header row

Sat, 26 Mar 2011 17:41:49 GMT

Hi Luca,

It is possible to set color in visualcases tab. But you need to set same color for upper lower and normal values. For sure this will take a long time to apply for many tables.

I was just looking for an easier way. But I will go with tihs method.

Thanks anyway.

Kind Regards

background color for the header row

pover — Sat, 26 Mar 2011 18:29:39 GMT

If you there is no business rule controlling the color why don't you use the Personalize Cell Format function? You have to display the grid in QlikView first and then you do a right-click -> Personalize Cell Format to change the color of certain rows or columns and you can distinguish between the cells that are headers or part of the body.

Regards.

background color for the header row

Sat, 26 Mar 2011 19:27:48 GMT

Thanks Karl,

I did not know what that was used for. You helped very much.

Kind regards.

background color for the header row

pljsoftware — Sun, 27 Mar 2011 12:25:50 GMT

Hi Karl,

can you explain me where to find "Personalize Cell Format"?

Thanks
Luca

background color for the header row

pover — Sun, 27 Mar 2011 17:27:09 GMT

Hi Luca,

1. Click View->Grid Design
2. Right-click on a straight or pivot table and select "Custom Format Cell"

Regards.

background color for the header row

pljsoftware — Mon, 28 Mar 2011 11:48:21 GMT

Thaks Karl, this is an interesting feature for me.

Regards
Luca

Re: background color for the header row

eleni_theodorid — Wed, 09 Nov 2011 13:23:56 GMT

Dear All,

I have exact the same problem. I have already tried to solve it by using the "Custom Cell Format" but it didn't work. Specifically, as you can see in the attached document, it works for the label text but not also for the background. Any ideas?

Regards,

Helen