Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

Export Multiple Chart Objects to Excel and Loop by Field

autopilot
Contributor III

Export Multiple Chart Objects to Excel and Loop by Field

This is an extension of this post: VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Valu...

The macro will export each chart (straight/pivot) to an Excel workbook for each possible value in the designated field.

Here's a basic example to illustrate:

- 2 Objects for export

---- A pivot table and straight table.

- 12 possible field values to loop during export

---- Month is designated as the field to loop.

Output = a single Excel file with 24 worksheets (i.e. one worksheet per object-Month).

This can be a helpful utility because of the ease to scale and drastic reduce time needed to perform the iterative exports. For example, a finance team needing to extract the profit-loss, balance sheet, and cash flow objects from QlikView for each financial Cost Center.

The macro script is attached in a text file.

Comments
beck_bakytbek
Honored Contributor

Thanks a lot for this helpful contribution

Beck

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-10-29 01:54 PM
Updated by: