Inserting a native table in PowerPoint reports
You can use tables and columns in Qlik NPrinting PowerPoint reports.
Creating a new PowerPoint report
Do the following:
- Select Reports in the Qlik NPrinting main menu, and then click Create report.
- Enter a Title for the report. PowerPoint Native Tables.
- Select PowerPoint from the Type drop-down list.
- Select an app from the App drop-down list.
- Keep the Enabled check box selected.
- Click Create to create the report.
Adding QlikView objects as tables to the template
Do the following:
-
Click Edit template to open the Template Editor.
- Right-click the Tables node, and select Add objects.
- Add CH318, CH319, and CH317 from the objects list.
- Drag and drop the CH317 node onto the first slide.
- Insert a new slide.
- Expand the CH318 node.
- Select all four fields and drag and drop them onto the second slide.
- Select the table in the slide.
- Select the Design ribbon tab under Table Tools.
- Select a table style.
- Clear the Keep Source Formats check box in the Properties section in the left pane.
- Insert a new slide. Expand the CH319 node.
- Drag and drop the Salesman tag onto the third slide.
-
Click Preview in the template editor, and view the results in the three slides.
- Click Save and Close to save the template.
You can use QlikView objects that have calculated dimensions or null values as levels. However, you cannot nest other objects inside them, except for fields from that sheet object. Qlik Sense visualizations with calculated dimensions cannot be used as levels.
There are two useful table properties that can be used to modify QlikView data displayed in the PowerPoint slides. They will not work with Qlik Sense data:
- Custom Rows
- Show Totals
Custom Rows is used to control the number of rows displayed in a table. For example, if you have a Sales table in QlikView that is sorted by Sales description and has 1000 rows, you may want to reduce the number of rows displayed in PowerPoint.
The range of rows that you want to display is entered in the format x-y (for example, 1-10 or 5-20). If y is greater than the maximum number of rows in the table (excluding Header and Totals rows), then only the number of rows available after x will be exported (total number of rows = 100, range 80-110, resulting rows displayed = 80-100).
The Show Totals check box allows you to export a table with or without the totals row of the QlikView table. This property is only available if the table has a totals row that can be detected by Qlik NPrinting.