Qlik Community

QlikView Documents

Documents for QlikView related information.

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

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.

Honored Contributor

Thanks a lot for this helpful contribution


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