Designing tabular report templates
With tabular reporting, you can design Excel-based reports containing large, detailed datasets. You design these templates in the Qlik add-in for Microsoft Excel. Generated reports can be in .xlsx or PDF format.
Tabular report generated from Qlik Cloud Analytics
What is tabular reporting?
Tabular reporting is built for spreadsheet-style report authoring and consumption. Using the Qlik add-in for Microsoft Excel, develop report templates based on your Qlik Sense app. When templates are ready, upload them into the Qlik Sense app for use in scheduled and on-demand reporting.
Data can be added in a number of ways, including:
-
Chart images
-
Column-level tabular data from a chart
-
Variables defined in the source Qlik Sense app
-
Expressions using the native Qlik Sense calculations
-
Native Excel calculations applied to tabular data
You can loop the report elements over field and chart values, creating new filtered sections and worksheets based on these discrete values.
Developing tabular report templates
The following help topics can help you learn about creating tabular report templates.
Installing the Qlik add-in for Microsoft Excel
Activating and getting started with the add-in
Adding content to your template
- Adding content to report templates with Qlik add-ins for Microsoft Office
- Adding charts as images to report templates with Qlik add-ins for Microsoft Office
- Adding tabular data to report templates with Qlik add-ins for Microsoft Office
- Formatting properties for tabular data in Excel report templates
- Working with native Excel tables
- Removing rows with the Deleterow tag
- Using variables and expressions in report templates with Qlik add-ins for Microsoft Office
- Working with levels and pages in tabular report templates
- Removing content from report templates with Qlik add-ins for Microsoft Office