topic Merging Sheets in QlikView https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011468#M955369 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 17 Nov 2015 15:29:47 GMT 2015-11-17T15:29:47Z Merging Sheets https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011468#M955369 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 17 Nov 2015 15:29:47 GMT https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011468#M955369 2015-11-17T15:29:47Z Re: Merging Sheets https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011469#M955370 <HTML><HEAD></HEAD><BODY><P>As far as I know you can't copy sheets from one document to another. See for example this discussion: <A href="https://community.qlik.com/message/845364">Copy sheet</A>. Perhaps it can be done with a macro.</P></BODY></HTML> Tue, 17 Nov 2015 16:18:15 GMT https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011469#M955370 Gysbert_Wassenaar 2015-11-17T16:18:15Z Re: Merging Sheets https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011470#M955371 <HTML><HEAD></HEAD><BODY><P>If you have the same data, with the same field names, you should be able to copy and paste objects. Other things to check:</P><P></P><P>- variables? Do you use variables in your chart expressions?</P><P>- Show/Hide conditions? do you need to take care of those?</P><P></P><P>After pasting the objects in the target QVW, check Sheet Properties &gt; Objects, and verify whether your objects are hidden.</P><P></P><P>cheers,</P><P>Oleg Troyansky</P><P><A href="http://www.amazon.com/gp/product/1118949552/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1118949552&amp;linkCode=as2&amp;tag=natursyner0f-20&amp;linkId=64QJ6MD3O54VZHF7" rel="nofollow">Check out my new book <EM>QlikView Your Business</EM>: An expert guide to Business Discovery with QlikView and Qlik Sense</A><IMG alt="" border="0" height="1" src="http://ir-na.amazon-adsystem.com/e/ir?t=natursyner0f-20&amp;l=as2&amp;o=1&amp;a=1118949552" style="border: none !important; margin: 0px !important;" width="1" /></P></BODY></HTML> Tue, 17 Nov 2015 16:32:19 GMT https://community.qlik.com/t5/QlikView/Merging-Sheets/m-p/1011470#M955371 Oleg_Troyansky 2015-11-17T16:32:19Z