Inserting a native table in PowerPoint reports

You can use tables and columns in Qlik NPrinting PowerPoint reports.

Create new PowerPoint report

Do the following:

1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
2. Enter a Title for the report, for example: PowerPoint Native Tables.
3. Select PowerPoint from the Type drop-down list.
4. Select an app from the App drop-down list. For example, select Sales Demo.
5. Keep the Enabled check box selected.
6. Click Create to create the report.

Add QlikView objects as tables to the template

Do the following:

1. Click Edit template to open the Template Editor.

2. Right-click the Tables node, and then select Add objects.
3. Add CH318, CH319, and CH317 from the objects list.
4. Drag and drop the CH317 node onto the first slide.
5. Insert a new slide.
6. Expand the CH318 node.
7. Select all four fields and drag and drop them onto the second slide.
8. Select the table in the slide.
9. Select the Design ribbon tab under Table Tools.
10. Select a table style.
11. Clear the Keep Source Formats check box in the Properties section in the left pane.
12. Insert a new slide. Expand the CH319 node.
13. Drag and drop the Salesman tag onto the third slide.

14. Click Preview in the template editor, and view the results in the three slides.

15. Click Save and Close to save the template.

There are two useful table properties that can be used to modify the data displayed in the PowerPoint slides:

• 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.