Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Edit Multiple Graphs at Once

I have a set of graphs, a 3x7 set up, each is a single LED traffic light and it is an overview of the overall business. The expressions that go into each graph are, for example,

sum({<Category={Product1}>}[Sales (Actual)])/sum({<Category={Product1}>}[Sales (Plan)])-1

I do this for products 1 through 7, then repeat for Sales Actual vs Sales Prior Year and Sales Actual vs Sales Last Period, which gives me a 3x7 matrix of traffic lights. Is there any way that I can type this expression once then clone the graphs and simply mass-edit all of the graphs on the second line to change "Actual" to "Plan" without going in individually and changes each one? This would save me so much time!

What about, for the same graphs, is it possible to select all of them and change their ranges all at once rather than going in, individually, and changing each one?

Tags (4)
1 Solution

Accepted Solutions
mayilvahanan
Not applicable

Re: Edit Multiple Graphs at Once

Hi

Try like this

Alt+Ctrl+E, you can able to see the expression overview , from that you can find/replace the field as you want..

Hope it helps

5 Replies
mayilvahanan
Not applicable

Re: Edit Multiple Graphs at Once

Hi

Try like this

Alt+Ctrl+E, you can able to see the expression overview , from that you can find/replace the field as you want..

Hope it helps

Not applicable

Re: Edit Multiple Graphs at Once

is there a way to clone instead of copy objects?

mayilvahanan
Not applicable

Re: Edit Multiple Graphs at Once

Hi

In layout properties-> tick the Allow copy/clone object. From that, you can able to clone/copy the object.

or

right click the object, you can see the clone option in it..

Hope it helps

Not applicable

Re: Edit Multiple Graphs at Once

I mean, I want to clone an object and when I paste it, I want it to be in a different location than the original (when you clone, it's slightly offset, whereas a copy-paste is in the exact same spot), but not everything seems to have Clone as an option, just Copy.

mayilvahanan
Not applicable

Re: Edit Multiple Graphs at Once

HI

You can drag the object and place it where you want, before that tick allow move/size in layout properties.

Suppose you want to copy to different sheet/document, right click the object, you can see copy to clipboard -> object

Then go to the sheet where you want to paste it, right click in the sheet, and select paste sheet object. And move the object where you want.

hope it helps