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:
- SalesData_Country1_Year1.xlsx
- SalesData_Country1_Year2.xlsx
- SalesData_Country2_Year1.xlsx
- SalesData_Country2_Year2.xlsx
- SalesData_Country3_Year1.xlsx
- 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.
If your reports contain conditions and filters, they will be evaluated in this order: Task filter > user filter > report filter > condition. Conditions are not evaluated separately for each report in the cycle
Limitations
Creating a new report cycle
Do the following:
- Click the Reports tab.
- Choose a report, and click the Enable cycle check box.
- Under Cycle, select a Connection and Field to cycle. We recommend choosing 3 or fewer Fields.
- Click Save.
The next time your report is distributed, it will be as a .zip file containing multiple files.
Troubleshooting
The folder containing my cycled reports shows reports with the FAILED label
Possible cause
Your reports contain incompatibility filters.
Proposed action
Check the filters associated with the report. For example, you have 2 filters:
- The first contains → Year: 2012, 2013
- The second contains → Year: 2014
If you use both filters, the intersection between the filters will produce an empty set.
My reports fail to generate
Possible cause
Your report uses the same dimension in the task, user, report, and object filter hierarchy.
Proposed action
Change or remove any filters that use the same dimension.