In NPrinting,
not only can you populate your Excel reports with data from your QlikView
documents, you can then add Excel objects into those reports and populate those objects using that data.
In this tutorial, you're going to learn how to create an Excel Pivot table
which is populated with data from a QlikView chart.
The first thing we want to do is to select an existing Excel report. We're
going to clone this report by clicking here.
We'll give the report a new name and then edit the template and save that
with a new name as well
to make sure we don't overwrite the template from old report. This is a simple
sales report
whose output looks like this. To create at a Pivot table in this report first we'll
open the Excel toolbar, then we'll select a range which includes the headers the
cells with fields in them and the cells immediately below the cells with the fields.
Now put your cursor here in Excel
and type in any name you want.
I'll call it three dimension.
Then hit enter
What we've done is to create a dynamic named range in Excel
called three dimension.
And if we click here in the name manager you can see that we have an object in
here called three dimension. Now select the worksheet where you want to put your
pivot table,
and click on it. Then click on insert, pivot table and insert the name of the named
range we created into the range for your pivot table and click on ok.
Now drag-and-drop your fields into the rows and columns
just like you would for any normal Excel Pivot table. You'll probably want to set
the summarization of sales from count
to sum.
You also have to make sure that you set the Pivot table to fresh data when opening
the file and also to retain none of the residual items for each field. Additional
formatting you'll probably want to do is
to remove this blank row
in your pivot table
by inserting the delete row function into column A into the row immediately below
the row which contains your fields.
Now if we save our template close it and preview the report,
the first worksheet is populated with our data just like in the original report
while the second worksheet contains a pivot table
populated from the data in the first worksheet with all the features
of a normal Excel Pivot table.
