background color for the header row

[#1]

Hi,

I need to change color for the header rows.

How can I do that?

Thanks in advance.

[pljsoftware]

Hi

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.

[#3]

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

[pover · Accepted solution]

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.

[#5]

Thanks Karl,

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

Kind regards.

[pljsoftware]

Hi Karl,

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

Thanks
Luca

[pover]

Hi Luca,

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

Regards.

[pljsoftware]

Thaks Karl, this is an interesting feature for me.

Regards
Luca

[eleni_theodorid]

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