topic Re: Extract in Excel - 2 Tables as one in QlikView https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384438#M512874 <HTML><HEAD></HEAD><BODY><P>Use Ctrl+M, a module would open where you can write a VBScript in Qlikview itself.</P><P><BR />Regards<BR />Pratyush</P></BODY></HTML> Tue, 31 Oct 2017 12:04:12 GMT prat1507 2017-10-31T12:04:12Z Extract in Excel - 2 Tables as one https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384435#M512871 <HTML><HEAD></HEAD><BODY><P>Hi Everyone!</P><P>i would like to have a suggestion.</P><P><SPAN style="font-size: 13.3333px;">I have 2 tables created as follow, which are 2 different element in QV. The need is to extract the two table in excel and have a unique excel to be sent out to several stakeholder. </SPAN></P><P><SPAN style="font-size: 13.3333px;">Currenlty i have to extract each table, and then merge the 2 extraction in one excel file. There's any way to extract just with one click the 2 tables? Maybe also using some other functionalities in qlik.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Thank you<BR /></SPAN></P><P></P><P> <IMG alt="Excel.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181606_Excel.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 31 Oct 2017 11:40:35 GMT https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384435#M512871 qlikviewaf 2017-10-31T11:40:35Z Re: Extract in Excel - 2 Tables as one https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384436#M512872 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can write a macro to add these two tables to an excel and format accordingly.</P><P></P><P>Regards</P><P>Pratyush </P></BODY></HTML> Tue, 31 Oct 2017 11:43:41 GMT https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384436#M512872 prat1507 2017-10-31T11:43:41Z Re: Extract in Excel - 2 Tables as one https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384437#M512873 <HTML><HEAD></HEAD><BODY><P>A macro, in excel you mean ?</P></BODY></HTML> Tue, 31 Oct 2017 11:59:33 GMT https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384437#M512873 qlikviewaf 2017-10-31T11:59:33Z Re: Extract in Excel - 2 Tables as one https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384438#M512874 <HTML><HEAD></HEAD><BODY><P>Use Ctrl+M, a module would open where you can write a VBScript in Qlikview itself.</P><P><BR />Regards<BR />Pratyush</P></BODY></HTML> Tue, 31 Oct 2017 12:04:12 GMT https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384438#M512874 prat1507 2017-10-31T12:04:12Z Re: Extract in Excel - 2 Tables as one https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384439#M512875 <HTML><HEAD></HEAD><BODY><P>Among other examples, this should work: <A href="https://community.qlik.com/message/1019924">Re: Macro to export multiple tables in to single excel</A></P><P></P><P>However, note that these macros will not work when you open the document via AccessPoint</P></BODY></HTML> Tue, 31 Oct 2017 12:41:24 GMT https://community.qlik.com/t5/QlikView/Extract-in-Excel-2-Tables-as-one/m-p/1384439#M512875 Miguel_Angel_Baeyens 2017-10-31T12:41:24Z