topic Re: Copy & Paste multiple linked objects in QlikView

Copy & Paste multiple linked objects

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

Hello,

In QlikView is there are way to copy multiple objects at the same time & paste them as linked objects? I've built a dashboard that has filters (list boxes) in the left column; each sheet in the dashboard will have the same filters. I want to copy all the list boxes from one sheet and paste them into the next sheet; the benefit of pasting them as linked objects is if I make a change to a list box on one sheet, the change will be made on all the sheets.

Kathleen

Re: Copy & Paste multiple linked objects

Anil_Babu_Samineni — Thu, 14 Sep 2017 16:32:30 GMT

You can do Ctrl + A and copy paste then remove unnecessary objects.

Re: Copy & Paste multiple linked objects

Anonymous — Thu, 14 Sep 2017 16:36:01 GMT

Hi Anil, that works but the objects paste as independent objects. . . . is there an easy way to paste them as linked objects?

Re: Copy & Paste multiple linked objects

Chanty4u — Thu, 14 Sep 2017 17:15:30 GMT

but

you copy normal but paste as Linked object next time when you add/delete something in the objects it will reflect to all

Re: Copy & Paste multiple linked objects

kaushiknsolanki — Thu, 14 Sep 2017 17:21:47 GMT

Once you select all object using Ctrl + A and copy them, then while pasting dont use Ctrl + v to paste them., instead right click on sheet and select option as paste sheet object as link.

Regards,

Kaushik Solanki

Re: Copy & Paste multiple linked objects

rwunderlich — Thu, 14 Sep 2017 17:23:23 GMT

When you paste. right-click and select "Paste as Linked Object".

Ctl-A will select all objects. You can also select any group of objects by:

1) Lasso the objects by holding down the left mouse button.

2) Holding Shift while clicking the caption on each object.

It's easier to see what's selected if you turn on the Design Grid (Ctrl-g). After selecting a group of objects, Ctrl-c to put them in the clipboard.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Copy & Paste multiple linked objects

Anonymous — Thu, 14 Sep 2017 18:02:53 GMT

Thanks for the help!

Re: Copy & Paste multiple linked objects

prananellutla — Fri, 15 Sep 2017 21:01:19 GMT

Hi will this be acting different in Qlik Sense? If I do Ctrl +A all the objects are not selected on my sheet. thanks

Re: Copy & Paste multiple linked objects

rwunderlich — Fri, 15 Sep 2017 22:11:35 GMT

afaik, Qlik Sense only allows copy of one object at a time.

-Rob

Re: Copy & Paste multiple linked objects

prananellutla — Mon, 18 Sep 2017 13:20:28 GMT

Okay- thank you

Re: Copy & Paste multiple linked objects

Chanty4u — Tue, 19 Sep 2017 09:33:46 GMT

if you want you need to duplicate the entire sheet and remove the objects which you don't want.

Re: Copy & Paste multiple linked objects

prananellutla — Tue, 19 Sep 2017 13:30:30 GMT

Yes I can do that but I will not have the benefit of pasting them as linked objects- therefore i need to make any change to every sheet if I am working on a global filter changes.

Re: Copy & Paste multiple linked objects

Chanty4u — Tue, 19 Sep 2017 13:32:28 GMT

Exactly,

if you want to be global changes paste it as a linked object only there is no otherway.

if you want to reuse the objects means you can duplicate the sheet.

Re: Copy & Paste multiple linked objects

rwunderlich — Fri, 22 Sep 2017 05:01:24 GMT

In QV, if the sheet you are copying contains linked objects, than the copied sheet will contain linked objects. So the flow is generally like this:

1. Create a 'Template" sheet that contains your common listboxes, current selections, search, logo etc.

2. To create a new sheet from the template, use the Ctrl-a, Ctrl-C, Paste Sheet object as link method.

3. For the next sheet, you can use the right-click "copy sheet" option on Template. The new sheet will have linked objects because the source sheet -- Template -- has linked objects at this point in time.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com