Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Export Table Excel

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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Export Table Excel

Hi Marco,

check my attachment.

Regards,
Fernando

View solution in original post

3 Replies
Partner
Partner

Re: Export Table Excel

Hi Marco,

check my attachment.

Regards,
Fernando

View solution in original post

Not applicable

Re: Export Table Excel

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
Contributor III

Export Table Excel

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