Formatting Word reports
When creating templates to generate Word reports, the default formatting setting is the QlikView or Qlik Sense formatting. However, you can also use the Word formatting tools.
Allow application of Word formatting for whole chart
After you have added a QlikView object as a table, for example CH184 in Creating Word reports, do the following:
- In the Template Editor, click the CH184 node of the object that you just added.
-
In the Properties window, clear the Keep Source Formats check box.
This will cause the contents of all cells in all columns of the table to be exported from QlikView without formatting.
- Click the Toolbar button.
Wrap text feature
Selecting Wrap Text causes Qlik NPrinting to automatically create two lines if the cell is too small. This works only when Keep Source Formats is not selected. Wrap Text is a table property that affects all columns of the table.
Apply Word formatting to entire table
Before adding the table to the template, do the following:
- Select the Insert tab on the toolbar.
- Select Table.
- Select the uppermost left cell to insert a 1x1 table into the template.
Add your table to the template
Do the following:
-
Expand the CH184 node.
-
Drag and drop them into the table cell in the template. You can select multiple values by keeping Ctrl or Shift pressed during the columns selection.
This will create all tags and insert them into a horizontal series of cells. The cells may exceed the page layout but this will be addressed in the following subsection.
Set table to AutoFit columns
Do the following:
- Select the Layout tab in the Table Tools section of the toolbar.
- Click AutoFit in the Cell Size section of the toolbar.
- Select AutoFit Contents.
Apply table style
After selecting the table, do the following:
- Select the Design tab in the Table Tools section of the toolbar.
- Select a general style in the Table Styles section of the toolbar.
Preview and save
Do the following:
- Click Preview.
- Check the report, close it, and then edit the template again if necessary.
- Click Save and Close to save the template and close the Template Editor.