Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
IAMDV
Master II
Master II

Changes to multiple Charts (Something like PasteSpecial in Excel)

Dear All,

I have 20 guage charts in my document and I have to make some changes across all the charts. This includes both expession & format changes... I don't want to go through the same changes manually for all 20 charts. Please can someone show me the light?

Cheers - DV

1 Solution

Accepted Solutions
disqr_rm
Partner - Specialist III
Partner - Specialist III

Hi DV,

For expressions, you could use Expression Overview from Settings Menu. And for format you can make changes to one chart and use Format Painter Tool button (with a brush on the toolbar) to copy the format to other charts. Just click on the source chart you want to copy format from and click this button, and then click on the target chart. This may not give you 100% of copy/paste solution, but may reduce good amount of manual work.

Hope this helps.

Rakesh

View solution in original post

8 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

Hi DV,

For expressions, you could use Expression Overview from Settings Menu. And for format you can make changes to one chart and use Format Painter Tool button (with a brush on the toolbar) to copy the format to other charts. Just click on the source chart you want to copy format from and click this button, and then click on the target chart. This may not give you 100% of copy/paste solution, but may reduce good amount of manual work.

Hope this helps.

Rakesh

Miguel_Angel_Baeyens

Hello,

If it's something related to format, use a template in the Layout tab of the chart properties, Theme Maker, and follow the steps to store th attributes you want the other objects to get.

If you want to change something (say a field name) in the expressions, then you can use the Settings menu, Expression Overview, and replace the old field name with the new field name.

Hope that helps.

IAMDV
Master II
Master II
Author

Yeah! This does not do the 100% job. I am storing all my large 3-5 set analysis expressions in the variables. Is this a good practice? Or Is there a better approach to calculate the expressions in the script? Right now I am using variable overiew...

Miguel_Angel_Baeyens

Hello,

Although you hardcode an expression in the script (or the variable overview) and you assign it to a variable, it will not be calculated until the variable is called (expanded). I sometimes use this with include files so the exchange of files is only about the variables text file and the user only has to replace this file and reload.

The advantage of doing in the variable overview is that you can change it in runtime without need of reload. The advantage of doing in the script is that you cannot accidentally (specially in the development process) accidentally delete or change one of these variables, and if you do, just reloading will get back to normal.

However, if you are not repeating expressions, my suggestion is that the chart itself is the best place to store them.

Hope this makes sense.

IAMDV
Master II
Master II
Author

Brilliant! very clear explanation. Many many thanks.

Not applicable

Don't forget you can use the double-click on Format Painter icon which will hold the settings you are transferring and then you can click on each individual (multiple) objects to format it the same as the original object, rather than clicking on the Format Painter button each time for all the objects.

IAMDV
Master II
Master II
Author

CheenuJanakiRam - Thank you for the tip. This will be handy!

Cheers - DV

Not applicable

"single click on format painter and hold ctrl key to apply to multiple objects" is this also possible?