topic Re: Excel export in the same file in QlikView

Excel export in the same file

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'am looking for make Excel exports in the same file.

Exemple : i make selection on Shop A, i export in Excel. So the first Excel file is created, after i select shop B, and make another Excel export, so a new one is created. What i'd like to obtain, is when i make the second (third,...) export, the export is stored in a sheet inside the first file.Is it possible?

Regards

Re: Excel export in the same file

Wed, 15 Feb 2017 06:00:24 GMT

Hi Jean,

May be it is possible with the help of Macro's only but i am not sure.

Re: Excel export in the same file

marcus_sommer — Wed, 15 Feb 2017 10:57:05 GMT

It's possible with macros. Here you will find various examples how to do it:

https://community.qlik.com/search.jspa?q=excel+export&type=document

- Marcus

Re: Excel export in the same file

vardhancse — Wed, 15 Feb 2017 11:08:09 GMT

See to the below thread:

Macro to export multiple tables in to single excel