How to Create a Pivot Table Report with QlikView Data
Excel Pivot tables can be created using levels (see: How to Create an Excel PivotTable Report), but the following method is simpler and quicker and we recommend it. Excel 2007 or a later version is necessary for this procedure. Here's how.
Create New Excel Report
Select Reports in the lower left pane
Select Excel Reports in the upper left pane
Click on Excel Report in the New group of the tool bar
Create New Template
Click on New in the Template group of the tool bar
Save New Template as .xlsx
The template must be saved in .xlsx or .xlsm format to be able store the information necessary for a pivot table.
Click on the Save As icon
Select Save as Type:
Expand the Save as type: drop-down menu and select Excel Workbook (*.xlsx)
Conclude Saving Process
Note that the file extension has been changed to .xlsx
Click on the Save button
Add Object as Table and Change "Keep Source Formats" Property
Add CH267 to the template as a Table (See: the "Add QlikView Objects as Tables: Selection" step in How to Create Excel Reports). Only QlikView Straight Tables can be used to create your template. If you want to use a QlikView PivotTable you must either convert it to a straight table or, to preserve the original, clone it and convert the clone. Then add the converted table to your template.