Reports with multiple connections

Reports can contain objects from more than one QlikView document or Qlik Sense app.

You can download the Sales Demo files at Sample files

Creating a new connection

Do the following:

  1. Select Apps from the Qlik NPrinting main menu, and then select Connections.
  2. Click Create connection.
  3. Enter a Name for the connection.
  4. Select an app from the App drop-down list.
  5. Add the connection information:

  6. Click Create.

    The generation of the cache starts automatically.

  7. While the first connection generates, create a second connection.
  8. Enter a Name, and select the same Qlik NPrinting app from the dropdown.
  9. Add the connection information for your second connection.
  10. Click Create.

Once both connections are Generated, you can start editing your report.

Creating a new Excel report

Do the following:

  1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
  2. Enter a Title.
  3. Select Excel from the Type drop-down list.
  4. Select an app from the App drop-down list.
  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.

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

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

Adding 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.
  5. Drag the CH317 - Top 5 Products node onto cell B10 in the template.

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

Saving the template

Do the following:

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

  2. When you have finished editing the report template, 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?