QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Creating Word reports

In Qlik NPrinting, you can create reports based on Word templates, filled with data from your QlikView documents or Qlik Sense apps, and then export the reports as .docx, .doc, .html, or .pdf.

In this example, you will embed the data of one QlikView object and the images of two others in a Word report, and then use two QlikView variables in a heading.

You can open an existing QlikView document or create a new one with at least one connection to the QlikView document SalesDemo.qvw. You can also customize the connection to use your own .qvw file. Word reports support MultiDoc.

Create new Word 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.Simple Word Report
  3. Select Word from the Type drop-down list.
  4. Select an app from the App drop-down list.
  5. Select a Template from the options available:

  6. Keep the Enabled check box selected.
  7. Click Create.

    If you click Cancel, the settings are deleted. If you instead want to save the report for future use, clear the Enabled check box and then click Create.

  8. Click Edit template to open the Template Editor.

Select QlikView objects to add as images

Do the following:

  1. If you want to use a connection different than the default one, open the Connection drop-down list and select the connection. You must have created the connection and the related cache to see it here.

  2. Right-click the Images node, and then select Add objects.
  3. Select QlikView objects, for example CH186 and CH212, to be included in your template as images.

    You can select multiple objects.

  4. Click OK.

Embed images in template

Do the following:

  1. If necessary, expand the Images node.
  2. Drag the CH186 node token onto the page, and then drag the CH212 node token onto the page.

After dragging an image onto the template, Qlik NPrinting drops a standard gray-scale image with the original object ID overlapped. You can then resize and/or move it onto the page just like in any Word document.

Add variables for heading

Do the following:

  1. If necessary, change the connection to the QlikView document that contains the variables that you want to use.
  2. Right-click Variables and select Add variables. The Select Variable window appears.
  3. Select the vCurrentYear and vLastYear variables from the list in the Select Variables window.
  4. Click OK.

Create and format heading

Do the following:

  1. Right-click anywhere at the top of the page, and then click Edit Header to start creating header content.
  2. Expand the Variables node in the left pane.
  3. Drag the vCurrentYear and vLastYear node tokens into the header section of the page, and then compose the heading.
  4. Highlight the heading, and then format it using the Word formatting tools.
  5. Select the Design tab.
  6. Click Close Header and Footer in the Close group.

Select object to add as table

Do the following:

  1. If necessary, change the Connection to the QlikView document that contains the entities you want.
  2. Right-click Tables in the left pane, and then select Add objects.
  3. Select the CH184 from Sales Demo in the Select Objects window.
  4. Click OK.

Tables that have calculated dimensions or null values can be used as levels, but you cannot put any objects or levels inside them. In these levels, made by normal and calculated dimensions (and other expressions), you can only add their fields. You cannot add images, tables, or formulas.

Embed table

Do the following:

  1. Expand the Tables node.
  2. Drag the CH184 node token onto an empty space on the page.

Preview and save

Do the following:

  1. Click Preview.
  2. Check the report, close it, and then edit the template again if necessary.
  3. Click Save and Close to save the template and close the Template Editor.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?