Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor III

Changing color in multiple sheets


I have to change the color of all the objects in all the sheets of a document, so I change the color in the active/inactive header settings (tag Header in Documents Propriety) and the color of the cursor bars and the borders (tag Presentation in the Documents Propriety), but all the object of the sheets didn't change at all (as I expected).

The second problem is that I'd like to change the tag color setting of all the sheets, but I didn't find where I can change this parameter in the global setting: have I to change this color sheet-by-sheet?

Does anybody help me, please?

Thank you very much.

4 Replies
Contributor III

Re: Changing color in multiple sheets


You want to apply same property for all object then select the source object and then select format painter from tool bar and move object on which have to apply same setting.


Nirav Bhimani

Re: Changing color in multiple sheets

Q1: Document Properties->Caption sets default values for all objects created subsequently.

You can use themes to change colors globally. See Object Properties->Layout for "Theme Maker" and "Apply Theme" buttons.

Q2: With "tag", do you mean "tab" of a worksheet? In that case you can change the tab color for a single sheet in Sheet->Properties->General->Tab settings, and propagate those new colors to every other sheet by clicking the "Apply to All" button.



New Contributor III

Re: Changing color in multiple sheets

I've tried it, but not all the properties has changes (e.g. the cursor bar colors didn't change...I don't know why).

However, doing so I should pass object-by-object with the format painter for every sheet of every document, so it takes me a long time to do.

I'd like to know if there is the possibility of change all object a-time, by setting the document's property (so I should make the changes only once for document).

New Contributor III

Re: Changing color in multiple sheets

Very good for the answer to Q2 :-)

I tried to make as you suggest for the Q1 and I create a Theme ad hoc with the characteristics that I'd like to set, but when I apply it on another document, only the sheet background and the tag setting are replaced; the active/inactive header color setting, the border color setting and the cursor bar color setting are not replaced.

Note that in the color theme wizard I specify all the properties to be included on the theme.



Community Browser