Sheet repeaters

Repeats a worksheet automatically, once per distinct value of a Qlik field, so a single sheet you design once becomes one tab per region, customer, or product when the template runs.

Where to find it

In the KPImailer pane, with a sheet selected, set up the repeater for that sheet.

How it works

Choose the field to repeat by - for example Region or Customer_ID - and the sheet is duplicated once for each distinct value the field has at run time, with that sheet’s Qlik objects and tokens scoped to its own value. It’s the template equivalent of bursting (cycle) on a report: instead of one combined sheet, each value gets its own.

Worked example

A regional sales workbook has one “Region overview” sheet designed once, with a sales chart and a KPI tile. Setting its repeater field to Region turns that single sheet into one tab per region - “North”, “South”, “East”, “West” - each showing only that region’s data, without redesigning the layout four times.

Caution

A field with many distinct values produces many sheets. Check how many distinct values a field has before repeating by it, the same way KPImailer warns about large bursting fields on reports.