topic Fast copy and paste formats for charts in QlikView

Fast copy and paste formats for charts

tinkerz1 — Tue, 18 Aug 2015 09:54:36 GMT

Hi,

Is there a fast copy and paste for the whole document for charts, I have changed font colors and gridlines/colors.

Each chart takes an age to change surely there is a quck way.

Thanks,

Neil.

Re: Fast copy and paste formats for charts

Peter_Cammaert — Tue, 18 Aug 2015 09:59:49 GMT

You can use the Paintbrush toolbar icon. While normally only for single copies, double-click the icon and the paintbrush tool will remain active for as long as you don't deselect it (or press Esc).

[Edit] Replaced imaginary Ctrl-feature by the correct one.

Re: Fast copy and paste formats for charts

jonathandienst — Tue, 18 Aug 2015 10:02:43 GMT

Now that's something new for me! I never knew that you could hold the Ctrl-Key down to apply the paintbrush to multiple targets. Thanks Peter.

Re: Fast copy and paste formats for charts

sundarakumar — Tue, 18 Aug 2015 10:09:09 GMT

You can also double click the Paintbrush option to hold the selection.

Regards,

Sundar

Re: Fast copy and paste formats for charts

Tue, 18 Aug 2015 10:11:11 GMT

CTRL + A and CTRL + V

the above will copy all objects and paste them where ever you want in the other sheet

Re: Fast copy and paste formats for charts

Peter_Cammaert — Tue, 18 Aug 2015 10:12:52 GMT

Sorry Jonathan, my mistake. Double-clicking helps, Ctrl doesn't. My bad

Re: Fast copy and paste formats for charts

jagan — Tue, 18 Aug 2015 10:14:08 GMT

Thanks Peter for sharing this, I never aware of this.

Neil,

You can use the Format Painter Tool for copying the Formats as pcammaert suggested.

Regards,

Jagan.

Re: Fast copy and paste formats for charts

Peter_Cammaert — Tue, 18 Aug 2015 10:15:48 GMT

I do apologize Jagan. I mixed things up. Double-clicking works, Ctrl doesn't.

Re: Fast copy and paste formats for charts

jagan — Tue, 18 Aug 2015 10:16:00 GMT

Hi Peter,

Ctrl is also working in 11.2 SR5, not sure which version you are using.

Regards,

Jagan.

Re: Fast copy and paste formats for charts

Kushal_Chawda — Tue, 18 Aug 2015 10:16:09 GMT

Do the changes in one char . Do right click on the chart ->Go to Layout Tab ->Click on apply to (top right corner)->

select "Objects in this documents" and ("Only this object type" or "all objects")

Re: Fast copy and paste formats for charts

sundarakumar — Tue, 18 Aug 2015 10:17:40 GMT

works in SR12 too

Re: Fast copy and paste formats for charts

Peter_Cammaert — Tue, 18 Aug 2015 10:20:17 GMT

SR12. In that release, Ctrl-Paintbrush works only once while Doubleclick-Paintbrush stays active.

Funny that some versions do seem to correspond with my imagination. But that's QlikView...

Re: Fast copy and paste formats for charts

Kushal_Chawda — Tue, 18 Aug 2015 10:23:15 GMT

pcammaert‌

There is one more way. Click on object was format needs to be copied ->then click on Format painter tool -> Now press Ctrl and you can paste the format to many objects by holding the Ctrl

Re: Fast copy and paste formats for charts

Peter_Cammaert — Tue, 18 Aug 2015 10:27:11 GMT

Could be that my Ctrl-key is broken (both of them). Boss! I need a new laptop

Re: Fast copy and paste formats for charts

Peter_Cammaert — Tue, 18 Aug 2015 10:30:19 GMT

Ok, that's fixed then.

Doubleclick-Paintbrush will make the Paintbrush tool active until you click the tool again (or press Escape)

Ctrl-Paintbrush will keep the Paintbrush tool active as long as you keep the Ctrl-key depressed.

Thanks for your patience.