KPImailer templates are built in desktop Excel and PowerPoint, not in a proprietary designer. The KPImailer add-in inserts live Qlik objects into your workbook or deck. Everything else stays yours: formatting, formulas, PivotTables and charts.
Excel templates
- Insert tables, charts and KPIs from any Qlik sheet into any worksheet.
- Build your own PivotTables and formulas on top of the inserted data. They recalculate on every run.
- Sheet repeaters create one tab per region, store or customer.
- Conditional rendering shows or hides content depending on the data.
- Scope and filter overrides let one object use a different period or selection than the rest of the report.
- Dynamic naming puts dates or values into file and sheet names.
PowerPoint templates
- Slide repeaters build one slide per value.
- Show or hide individual shapes, or whole slides, with conditions.
Every other format too
The same report can attach formatted Excel that keeps Qlik styling and pivot indentation, raw data exported as an Excel table, PDF, paginated PDF and CSV. Each attachment can carry its own filters.
