Extract in Excel - 2 Tables as one - Qlik Community

qlikviewaf · ‎2017-10-31

Hi Everyone!

i would like to have a suggestion.

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.

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.

Thank you

prat1507 · ‎2017-10-31

Hi

You can write a macro to add these two tables to an excel and format accordingly.

Regards

Pratyush

qlikviewaf · ‎2017-10-31

A macro, in excel you mean ?

prat1507 · ‎2017-10-31

Use Ctrl+M, a module would open where you can write a VBScript in Qlikview itself.

Regards
Pratyush

Miguel_Angel_Baeyens · ‎2017-10-31

Among other examples, this should work: Re: Macro to export multiple tables in to single excel

However, note that these macros will not work when you open the document via AccessPoint