Formatting properties for tabular data in PowerPoint report templates
This help topic provides an overview of the available formatting properties for tabular data in a PowerPoint report template.
Applies to
This content applies to designing PowerPoint report templates using the Qlik add-in for Microsoft PowerPoint. See Qlik add-in for Microsoft PowerPoint.
Similar functionality exists for Word and Excel templates, with some notable differences. For more information, see:
Formatting properties for entire tables
In PowerPoint, tables added as single tags have the following Table settings:
-
Keep source formats: The add-in tries to keep the original object formats. By turning this setting off, you can apply customized PowerPoint formats to the table.
-
Display headers: Configure table column headers to be displayed or hidden.
If you change the Display headers or Keep source formats settings at the table level, you are prompted to automatically change any individual columns that have different values for these settings.
Each of these settings is explained in more detail below.
Adjustable settings for a Qlik Sense chart added with a single table tag
Keep source formats setting at the table level
In your PowerPoint template, the Keep source formats setting is turned off by default. This allows you to add custom styling to the table tag using the native PowerPoint features. With Keep source formats turned on, the table is rendered with minimal formatting.
When Keep source formats is turned on for a table or column in your template, you may encounter formatting differences between Qlik Sense objects and generated report objects. If you find that your report does not match the Qlik Sense app, you can turn off Keep source formats for a table or column and customize the report template manually.
The image below is an example of the output generated from a single table tag highlighted in yellow, with Keep source formats turned off.
Report output from template with single table tag highlighted in yellow
Header settings at the table level
Use the Display headers setting to configure column headers for the entire table. You have two options:
-
Show (default): Table headers are added to the top of the table automatically.
-
Hide: Table headers are removed from the table. This option is suitable if you do not need headers, or if you want to manually add headers for the table at a later time.
Formatting properties for individual columns
Keep source formats and Display header can be defined separately for each column.
If you change the Display headers or Keep source formats settings at the table level, you are prompted to automatically change any individual columns that have different values for these settings.
Each of these settings is explained in more detail below.
Keep source formats at the column level
Keep source formats can be set at the column level to customize the formats of every single column. Click on a column tag and uncheck the related Keep source formats checkbox. Alternatively, open the table in the Tables objects within the add-in, and expand the column. Then, uncheck the checkbox.
With Keep source formats turned on, the column is rendered with minimal formatting.
Changing the Keep source formats value at the table level will change the value of this setting for all individual columns in the table. For information about setting this at the table level, see Keep source formats setting at the table level.
Changing formatting properties for individual columns in a PowerPoint report template
When Keep source formats is turned on for a table or column in your template, you may encounter formatting differences between Qlik Sense objects and generated report objects. If you find that your report does not match the Qlik Sense app, you can turn off Keep source formats for a table or column and customize the report template manually.