This tutorial is intended to illustrate the capabilities of the latest NPrinting version when creating Excel reports. It is presumed that you are familiar with common NPrinting procedures.
Open an existing NPrinting document or a new one. We will use a sample QlikView document, SalesDemo.qvw, for this tutorial, which can be downloaded from here. Establish a connection to it (see Connect to a QlikView document).
Import an image of a QlikView object:
QlikView objects added as images appear exactly the same as in QlikView. The data are not modifiable.
Images can be embedded side by side as well.
Click on the lower part of the Preview icon to select previewing in a particular output format
QlikView objects added as tables can appear exactly the same as in QlikView or formatting can be modified partially or completely. The data are modifiable.
Table CH184 is four columns wide, so move CH186 and CH187 tags five columns to the right to leave one column between the table and the images.
Pivot tables do not have component nodes, while straight table nodes can be expanded to show their component column nodes. These column nodes can be embedded individually or used as components of a different table.
Repeat the close Excel, Edit template and Preview cycle until you get the report you want. Close Excel and proceed.
Levels create tables and charts that are cycled through the values of the level field. The results for each level field value are displayed one after the other.
Drag the Quarter_Level node token into the template and drop it onto three, vertically-consecutive, empty cells.
The Quarter tag will display as the quarter relevant to the data displayed in the charts and tables.
Your report can be produced with a page for each Year, Month, Quarter, Customer, Country, etc. For example, to produce a page for each year:
Select Preview in the Actions group in the Report window
Your report will now be produced with a page for each year having the year as title.
Tip: To avoid having a cell or cells selected in your distributed reports, always select a cell away from your report elements just before Saving and Closing the Template Editor window at the end of what you think to be your last edit.