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.
