Merging Sheets

[#1]

I have two different qvw files but both use the same qvd's as source for their sheet objects. How do I copy the sheets from qvw2 to qvw1? Copy Objects and pasting them in the qvw1 isn't ideal as I don't see the data.

[Gysbert_Wassenaar]

As far as I know you can't copy sheets from one document to another. See for example this discussion: Copy sheet. Perhaps it can be done with a macro.

[Oleg_Troyansky]

If you have the same data, with the same field names, you should be able to copy and paste objects. Other things to check:

- variables? Do you use variables in your chart expressions?

- Show/Hide conditions? do you need to take care of those?

After pasting the objects in the target QVW, check Sheet Properties > Objects, and verify whether your objects are hidden.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView an...