In this section we will create an HTML template using QlikView objects. We will use a Chart (Line Chart), a Table and a Variable.
To create an HTML template, go to Templates tab and click Create button. Your screen will look something like this:
- In the Type drop-down menu select HTML
- Give a name to your template. Example: Performance HTML template
- It is recommended to add a description
- You have two options to create a new template. You can click to create a new HTML file or click to create your template from an existing HTML file.
- Save your work
Click to create a new HTML file. Your screen will look something like this:
- An HTML file is open in the Qalyptus application
- Used: list of the selected objects and variables to use to create your template
- Objects: list of the table and chart objects of the selected connections
- Variables: list of the variables of the selected connections
- Connections: list of the available connections.
Now you need to add to the HTML file the objects you want to have in the file. In our case we will use the Performance connection and use the following items:
- Sales Trend (CH137) as Image
- Sales Performance (in thousands) (CH169) as Table
- vCurDate as Variable
Follow the instructions below to add the items.
- Go to the Connection tab and select Performance connection
- Go to Objects tab -> find Sales Trend (CH137) > right click and choose Use as image
- In Objects tab find Sales Performance (in thousands) (CH169 ) > right click and choose Use as table
- Go to Variables tab -> find vCurDate right click and choose Use the variable
- Return to Items tab. You objects and variable are now available to be arranged in the file.
- Add the text Date
- Drag and drop vCurDate at the right of the text Date
- Drag and drop CH137 (Sales Trend) and adjust it
- Drag and drop the CH169 (Sales Performance (in thousands))
Click Preview button and choose Http to view the result
- An HTML file is created
Click Save button to save the file
- Close the window
When generating the report only objects and variables present in the Used tab are taken into account. Example: if the object CH137 is used in the HTML file and the object CH137 is not used in the Used tab, then the object CH137 will not be created in the HTML file at the time of the generation of the report.
A template can have three different status:
- Valid template
- File not found
- No objects or variables used