Skip to main content

Repeat Sheets and row ranges

Overview​

The repeating options in Qalyptus allow you to dynamically create multiple Excel sheets or repeated row ranges within a sheet. These features enable you to iterate over Qlik Sense field values and generate reports that automatically expand with filtered charts, tables, and variables.

Repeat Excel sheet​

You can repeat charts, tables, and variables to create a new sheet for each value of a Qlik Sense dimension. Qalyptus automatically filters the content of each sheet based on the dimension value.

To repeat a sheet:

  1. Edit the Excel report template.
  2. Add the desired Qlik Sense objects (charts, tables, variables) to the Excel sheet and keep the sheet active.
  3. In the Overview tab, click the three dots button next to the Repeat node and select Add iteration field.
  4. In the field list, select a field and click Add.
  5. The field will be added to the Repeat node.
  6. Click the three dots button next to the added field and select Repeat sheet.
  7. The repeat tag will replace the active sheet name. Ensure you have activated the desired sheet before applying this option.

When you generate the report, Qalyptus will create a sheet for each value in the field and filter all the objects in the sheet accordingly.

tip

You can copy the repeat tag added to the sheet name and paste it into any cell within the sheet. The tag will be replaced by the field value in the generated report.

warning

When using Repeat Sheet, keep in mind the Excel worksheet name constraints:

  • Maximum length: 31 characters.
  • Invalid characters: : \ / ? * [ ].
  • Names cannot begin or end with a single quote '.
  • Names must be unique within the workbook.
  • The reserved name History cannot be used.

If the sheet names generated from the iteration field do not comply with these rules, Qalyptus will handle certain issues automatically (such as trimming invalid characters).
However, other constraints cannot be resolved automatically, and in those cases Qalyptus will raise an error.

Repeat row range​

You can also repeat a row range within an Excel sheet that contains charts, tables, or variables. Qalyptus will generate the same range for each value of the selected repeat field, stacking them one below another.

To repeat a row range:

  1. Edit the Excel report template.
  2. Add the desired Qlik Sense objects (charts, tables, variables) to the Excel sheet and keep the sheet active.
  3. In the Overview tab, click the three dots button next to the Repeat node and select Add iteration field.
  4. In the field list, select a field and click Add.
  5. The field will be added to the Repeat node.
  6. Click the three dots button next to the field and select Repeat.
  7. Repeat tags (start tag, end tag, and title) will be added to the active sheet. Ensure the desired sheet is active before applying this option.
  8. Place the Qlik Sense objects between the start and end repeat tags.
  9. Click Preview to see how the report will look when generated.
tip

Nested Repeats:
Qalyptus supports combining Repeat sheet and Repeat row range in the same report. You can also nest a repeat row range inside another repeat row range for more advanced and flexible reporting scenarios.