Embedding a QlikView sheet in a Microsoft Office or HTML report

A QlikView sheet can be exported directly from QlikView as an image. Supported formats are PNG, JPEG, BMP or GIF. QlikView automatically sets the image dimensions to include the entire sheet.

A QlikView sheet can also be used in QlikView reports. Select the QlikView sheet that you want to use in the list, and then add it as an image to a Microsoft Office, HTML or PixelPerfect report template. In this case, the available output formats those supplied by the used report type.

Create a new HTML 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:HTML report containing a QlikView sheet.
3. Select HTML from the Type drop-down list.

4. Select an app from the App drop-down list. For example, select Sales Demo.

5. Leave the Enabled flag checked.
6. Click Create to create the report.
7. Click Edit template to open the Template Editor.
8. Right-click the Images node, and then select Add objects.

9. Select the Connection to the QlikView document that contains the object you want. For example, select Sales Demo.

10. Select one QlikView sheet from the list.

    For example, select SH30.

11. Click OK.
12. Drag the SH30 node token into the template and drop it on the line between the body tags.

13. To check the result, click Preview.

    The QlikView sheet will be exported as a single image.

Information noteNote that the aspect ratio and content of the preview image depends only on the aspect ratio and visible content of the sheet in QlikView. It does not depend on the visible dimensions of the QlikView window.
14. To close the template editor without saving, close its window.

15. To save the template in the repository and keep the editor open, click on the Disk icon in the upper left corner.

    We suggest saving often as there is not an auto-saving feature.

16. To store the template in the repository, click Save and Close.