Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikviewaf
New Contributor III

Extract in Excel - 2 Tables as one

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

Excel.PNG

4 Replies
prat1507
Valued Contributor

Re: Extract in Excel - 2 Tables as one

Hi

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

Regards

Pratyush

qlikviewaf
New Contributor III

Re: Extract in Excel - 2 Tables as one

A macro, in excel you mean ?

prat1507
Valued Contributor

Re: Extract in Excel - 2 Tables as one

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


Regards
Pratyush

MVP
MVP

Re: Extract in Excel - 2 Tables as one

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