Export Table Excel

[#1]

Hi!

I need to export in excel format one table in qlik.

I add the file ex.qwd where there is a part of my database and the table that i would export.

The table name is CH01 and i need to create a button (i think connect to a macro) to export table CH01 in a excel file  City.xlsx.

Important: There are two selections of the Table CH01 by Date and Status.

Can you help me?

Thank you

[fosuzuki · Accepted solution]

Hi Marco,

check my attachment.

Regards,
Fernando

[#3]

Hi Fernando!!

It's perfect and you solve my problem.

An other question.... i have also more sheets with 1 or more charts like the example.

For ex: Sheet:  Sheet1  Chart:  CH01

           Sheet:  Sheet 2  Charts: CH02 CH03

Is it possible to Export the Charts in one excel file with only one button/macro?

How can I modify the macro?

Thanks a Lot!!

Marco

[pljsoftware]

Hello Marco,

try this Exporting multiple QV objects to a single Excel document I think that it solve your problem.

Regards

Luca Jonathan Panetta

PLJ Software