Cycling your reports

You can generate multiple versions of a report broken down by dimension, such as year or region. Instead of one report, several reports are generated in a zip file. If you have more than one cycle field, you will get as many reports as the combination of all cycle fields.

For example, you have a Qlik NPrinting Excel report called SalesData that you want to cycle by Country and Year. Your data covers 3 countries and 2 years, so you will get 6 reports in your zip file:

1. SalesData_Country1_Year1.xlsx
2. SalesData_Country1_Year2.xlsx
3. SalesData_Country2_Year1.xlsx
4. SalesData_Country2_Year2.xlsx
5. SalesData_Country3_Year1.xlsx
6. SalesData_Country3_Year2.xlsx

Once created, the zip file will be sent to every selected report destination, the same as a standard report. Report cycling works with all distribution methods.

Creating a new report cycle

Do the following:

1. Click the Reports tab.
2. Choose a report, and click the Enable cycle check box.
Information noteOnce you choose Enable cycle, dynamic report naming becomes mandatory. The fields you choose to cycle through will be automatically included in the report name, but this can be customized under Dynamic name. See: Dynamic naming of reports.
3. Under Cycle, select a Connection and Field to cycle. We recommend choosing 3 or fewer Fields.
4. Click Save.

The next time your report is distributed, it will be as a zip file containing multiple files.