Creating a report with objects from different QlikView documents

You can create reports by incorporating objects from more than one QlikView document. This page presents how you can connect more than one QlikView document to a single report and add one or more objects from each connected QlikView document to the report. You will use an Excel template.

Create a new connection

Do the following:

  1. Select Apps from the Qlik NPrinting main menu, and then select Connections.
  2. Click Create connection.
  1. Enter a Name for the connection. For example, enter Budget.
  2. Select Sales Demo from the App drop-down list.
  3. Enter the complete document path of the QlikView document that you want to add. If the .qvw file is saved on the computer where Qlik NPrinting is installed, the path is relative to that computer.

    In this example, enter C:\NPrintingServer\QlikViewDocuments\Samples\Budget.qvw. To open a document from a network location you must use the Universal Naming Convention in the path. You can also open a .qvw file from a QlikView server.

  4. Click Create.

    The generation of the cache starts automatically. You have to wait until the end of the process to be able to use objects from this document in your reports.

Create a new Excel report

Do the following:

  1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
  2. Enter Simple MultiDoc Excel Report as the Title.
  3. Select Excel from the Type drop-down list.
  4. Select an app from the App drop-down list. For example, select Sales Demo.
  5. Leave Enabled check box selected.

    If you clear the Enabled check box, the report will persist in the repository but will not be generated. This can be useful during the development of the report. You can select Enabled when the development of the report is complete. You may also want to clear Enabled to prevent the generation of a report that you want to save for the future.

  6. Click Create to create the report.
  7. Click Edit template to open the Template Editor.

Add an object from Budget to the template

Do the following:

  1. Right-click the Tables node, and then select Add objects.
  2. Open the Connection drop-down list in the Select Objects window and select Budget.
  3. Find and select the CH332 - Top 5 Products object in the objects list.

    You can use Search to find the object name or ID.

  4. Click OK.

    You can also double-click the object row to add it to the node of the preview.

Embed chart CH332 as a table in the template

Do the following:

  • Drag the CH332 - Top 5 Products node onto a cell on the template, for example, B6.

    The object tag, <CH332>, is replaced by its content in the QlikView document when the report is generated.

Add an object from Sales Demo to the template

Do the following:

  1. Right-click the Tables node, and then select Add objects.
  2. Open the Connection drop-down list in the Select Objects window and select Sales Demo.
  3. Select CH317 - Top 5 Products from the list.
  4. Click OK.

Embed chart CH317 as a table in the template

Do the following:

  • Drag the CH317 - Top 5 Products node onto cell B10 in the template.

Add table headings

You can add fixed strings in a report template, and use the formatting feature of the selected report format to customize them. For instance, you can add headings for the tables by merging cells B5-E5 and B9-E9, inserting the text, and then formatting it.

Run a preview

You can check the final report, filled with your data, at any time during development.

Do the following:

  1. Click the Preview icon in the ribbon bar to get a preview in the default output format.
  2. Open the drop-down menu by clicking the small arrow under the lens to select a different output format among the ones available.

The report is populated with two tables from two distinct QlikView documents.

Save the template

Do the following:

  • Click the small disk icon in the upper left corner of the window title bar to save the template.

    Save frequently because there is no auto-save feature.

  • When you have finished editing the report template, click Save and Close to save the template and close the Template Editor.

Filtering by using a linked field

Linked fields are the entities used in Qlik NPrinting to create a link among the same field on different documents. Linked fields are not yet available in QlikView. You can emulate the same behavior by creating one filter for each connection and applying them to the report.

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?