Extract in Excel - 2 Tables as one

[qlikviewaf]

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]

Hi

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

Regards

Pratyush

[qlikviewaf]

A macro, in excel you mean ?

[prat1507]

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

Regards
Pratyush

[Miguel_Angel_Baeyens]

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