How to Create HTML Reports

Stefano_Dalla_Guarda — Fri, 06 Nov 2015 11:35:13 GMT

This tutorial is intended to illustrate HTML report creation. It is presumed that you are familiar with common NPrinting procedures.

We are going to embed images of two QlikView objects in an HTML report in this tutorial, and then add a level and the level variable tag as the label to HTML report which will then have an appropriate title and images in a frame for each of three years.

Open an existing NPrinting document or a new one. We will use a sample QlikView document, SalesDemo.qvw, for this tutorial. Establish a connection to SalesDemo.qvw (see: How to Connect to your QlikView documents).

Add New HTML Report

Select Office Reports in the lower left-hand pane
Select the HTML reports in the pane immediately above
Select HTML Report in the New group of the tool ribbon

Create New HTML Report

Enter a Name for your report
Enter optionally a Description
Select New in the Template group of the tool ribbon.

Create New HTML Template: Open Select Objects Window for Images

Right click on the Images node icon or label in the left pane
Select Add objects

Select Connection and Objects to Add

Import images of QlikView objects:

If you need QlikView objects from a specific connected QlikView document, select the corresponding connection
Select the objects, Top 25 Products and Top 3 Countries in this case
Click on the OK button

Embed Images in Template

Expand the Images node in the left pane by clicking on the '+' to its left
Drag and drop the CH296 - Top 3 Countries, and CH184 - Top 25 Products tokens onto lines between the <body> and </body> tags. Add lines as necessary and some block element tags such as <p>, <table>, or <div> for layout management and inline style elements if necessary
Click on the Preview icon in the Actions group

Resulting Report

This resulting HTML report is the result of the code that follows:

<html>

Top 3 Countries

<h3>

Top 25 Products

<h3>

</body>

</html>

Open Select Levels Window

Your HTML report can be produced with levels. For example, to produce a level that cycles through each year:

Right click on the Levels node icon or label in the left pane
Select Add levels

Multi-Level HTML Report: Select Level

If you need a QlikView field from a specific connected QlikView document, select the corresponding Connection
Select the Year field from the list in the Select Levels window
Select OK

Add Year_Level to Template

Expand the Levels node in the left pane by clicking on the '+' to its left
Drag and drop the Year_Level node token onto a line between the <body> and </body> tags

Add lines if necessary. The result is three new lines, %%Year_Level%%, %%/Year_Level%% with a blank line between.

Place Content into Level Cycle

Arrange the %%Year_Level%% line before and the %%/Year_Level%% line after the elements that you want to be included in the level cycle.

Add Level Cycle Title

Expand the Year_Level node in the left pane by clicking on the '+' to its left
Drag and drop the Year node token onto a line between the %%Year_Level%% and the %%/Year_Level%% lines
Add inline style elements
Click on the Preview icon

Here is the code for this simple HTML report: