topic Apply Color map to all charts in QlikView

Apply Color map to all charts

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I want to define a standard set of colors(bar chart properties-->colors tab->Data Appearance section) for all charts in the document.

I clicked on Advanced button and defined some colors and tried to make it document default. But it seems that the changes(all set of colors) are not applied to all chart and are just stored as document default colors.

How can i apply the change to all charts ie using document default color map.

Thanks!

Re: Apply Color map to all charts

Gysbert_Wassenaar — Mon, 25 Jul 2016 17:31:51 GMT

Changing the default document colors will not change existing objects. You'll have to do that manually. Perhaps the Format Painter Tool (from the Design toolbar) can help a bit with that.

Re: Apply Color map to all charts

Chanty4u — Tue, 26 Jul 2016 06:16:46 GMT

Hi,

try to create colour codes in excel sheet and load that in Qliview and try to insert below script then u will get the same colurs whatevr u expected

chk below thread aswell

Re:Load colour

ColorCodes:

LOAD ColorNo,

ColorCode

FROM

[$(vFilePath)\ColorCodes.xlsx]

(ooxml, embedded labels, table is Sheet1);

Let vNumberOfRows = NoOfRows('ColorCodes');

For vI = 0 to (vNumberOfRows - 1)

Let vVariable_Name = Peek('ColorNo',vI,'Expression');

Let [$(vVariable_Name)] = Peek('ColorCode',vI,'Expression');

DROP Table ColorCodes;

NOte: ColourNo {1,2,3...}

ColourCode{RGB(255,255,0).....}

Re: Apply Color map to all charts

surajap123 — Tue, 26 Jul 2016 07:01:01 GMT

Hi Chanty,

Thanks for script.

My requirement is to apply the color changes to all charts at one go(because my dashboard has some 30 charts), instead of manually going to each chart(color tab-> Advanced tab-->update doc default).

Re: Apply Color map to all charts

Anonymous — Tue, 26 Jul 2016 07:55:40 GMT

Hi, Suraj,

Yes, as Gysbert pointed out, the modified document default color will not effect the exist objects. So you know that you must set this value when you start to create the dashboard in the future.

And in your case, the "format painter tool" helps. Pls notice that you need to double click on the target object to make the format work.

Zhihong