topic Re: How to replicate a sheet along with all objects?? in QlikView

How to replicate a sheet along with all objects??

Anonymous — Fri, 04 Dec 2015 15:33:10 GMT

Is it possible to make a copy of a sheet along with all of its chart objects from one Qlikview application to

another Qlikview application? I basically want to replicate a sheet say from a document called DEV.qvw to QA.qvw.

If this possible, can someone please explain the steps to accomplish this?

Thank you

Re: How to replicate a sheet along with all objects??

arasantorule — Mon, 07 Dec 2015 07:48:21 GMT

Hi,

Just Ctrl+A will copy all the object from the sheet.

Then paste the copied sheet in the new sheet or wherever required.

Thanks.

Re: How to replicate a sheet along with all objects??

Anonymous — Tue, 08 Dec 2015 13:19:28 GMT

I did try <CTRL + A> and paste. It appears most of the objects were copied but some were not. After looking into

it further, it appears objects inside a containers were not copied. Is there any special sequence in handling these? Thanks

Re: How to replicate a sheet along with all objects??

Tue, 08 Dec 2015 15:04:54 GMT

there are definately limitations with object in containers when either copying the sheet or container. If you copy the object from the container, be careful because they will be linked, and you may not want that

Re: How to replicate a sheet along with all objects??

roger_stone — Tue, 08 Dec 2015 15:49:21 GMT

Use CTRL-S as that will select the hidden objects as well as the visible ones.

Re: How to replicate a sheet along with all objects??

Anonymous — Wed, 09 Dec 2015 00:56:58 GMT

When I pressed CTRL+S in the source and pressed CTRL+V on the target sheet (2nd QVW), nothing happened

and nothing was pasted either. Do I hit CTRL-S then CTRL-C on the source sheet and finally CTRL-V on the

target sheet?? (Actually I tried it, nothing happened either). Can you explain?

Re: How to replicate a sheet along with all objects??

rwunderlich — Wed, 09 Dec 2015 01:43:51 GMT

‌ctrl-a, ctrl-c will not copy objects in a container. It will only copy the container itself. As a workarond, you can drag the objects out of the container before copying. Of course, you have to drag them back in on the target sheet. I know. It's a drag.

Rob

Re: How to replicate a sheet along with all objects??

SunilChauhan — Wed, 09 Dec 2015 05:14:43 GMT

copying container will not copy all object inside container .you need to remove all objects from container then do Control+A,Control+C and then to other app Control+V.

to make sure Data is available to New app. you can do binary load from one app to other. which will copy you data model from one to other.

Might help

Sunil

Re: How to replicate a sheet along with all objects??

Wed, 09 Dec 2015 05:44:32 GMT

Hi,

you may try this.

Click on object inside container

Select "Clone" (This creates a copy of object outside container)

Change object ID of cloned object to value that is referenced in container properties

Copy object and paste in destination QVW.

Re: How to replicate a sheet along with all objects??

Anonymous — Wed, 09 Dec 2015 15:01:17 GMT

OK, this is what I've done:

1. Dragged all objects out of the container (source app)

2. Pressed CTRL+A, CTRL+C

3. Opened target app

4. Pressed CTRL+C

I noticed all the objects from the container now have new Object ID's as I was comparing them to new old container

objects.

5. Re-added all the objects back to the container.

Everything appeared to be fine (visually) - nothing was missing.

After clicking on various selections, I noticed the values in the charts which are inside the container are not

changing. There are other objects on this sheet now have the same issue. However there are some are working.

What do I need to do to fix this? Once this is fixed, I think I'm good with everything copied over.

I appreciate everyone who has responded.

Re: How to replicate a sheet along with all objects??

Anonymous — Wed, 09 Dec 2015 16:07:20 GMT

OK. I was able to resolve the problem with the data not being reflected when I made various selections. I basically repeated the above steps excluding the container stuff. After that, I cloned each object inside the container and manually copy each object over to the new app;. This seems to do the trick.

Things are looking good except there is one "stubborn" pivot chart. This chart is by itself (not in container). The data is not changing no matter what I select. I even deleted it in the new app and re-created it using the same expressions from the old. I can't get the data in this pivot chart to reflect my selections. This is the last one I need to fix. Someone please help.

Re: How to replicate a sheet along with all objects??

Thu, 10 Dec 2015 02:32:23 GMT

did you select any alternate state?