How to Create MS Excel Charts from Qlikview Data

[Stefano_Dalla_Guarda]

This tutorial illustrates how to create a native Excel graph in your NPrinting reports. A table will be added to the template as a level. Fields will be embedded in the template and an Excel chart will be created with the data exported from QlikView.

    

Start New Excel Report Template and Open Select Levels Window

                   

                               

         

1. Right click on the Levels node
2. Click on Add level

Select Level

                   

                               

         

Add the Top 25 Products - CH184 as a level by:

1. Select the Connection SalesDemo to the QlikView document that contains the object you want
2. Type CH184 in the search box and select the Top 25 Products
3. Click on OK

Embed Level in Template

                   

                               

         

Drag the CH184_Level - Top 25 Products node into the template and drop it onto three vertically consecutive cells. I have dropped them into the 12th-14th rows to make room for the graph that I intend to place above.

Embed Fields for Columns

                   

                               

         

1. Expand the CH184_Level - Top 25 Products node by clicking on the '+' to its left
2. Drag the field nodes to be used into the template one at a time and drop them onto empty cells in a row between the level tags

Add Column Headings

                   

                               

         

Add headings in a row that is above the row containing the level opening tag and format them with the Excel formatting tools that are made visible by clicking on the Toolbar icon. The rows containing the level opening and closing tags will be eliminated during the table generation process.

Add Chart

                   

                               

         

1. Click on the Recommended Charts icon
2. Select a column chart
3. Confirm with OK

 

Begin to Define Chart

                   

                               

         

1. Select the Design tab
2. Click on the Select Data icon

Begin to Define Vertical Axis

                   

                               

         

Click on the Add button in the Legend Entries (Series) pane

Continue to Define Vertical Axis

                   

                               

         

Click on the icon at the right of the Series name.

 

Select Series Name = Vertical Axis Legend

                   

                               

         

1. Select the cell with the Total Sales heading
2. Confirm by clicking on the icon at the right end of the Edit Series field

Proceed to define Series values

                   

                               

         

Select the icon at the right end of the Series values.

Select Vertical Axis Range

                   

                               

         

1. Select the Total Sales range by including the cells in the rows containing the level opening and closing tags along with the cell containing the <Total Sales_1> tag
2. Confirm the selection by clicking on the icon at the extreme right end of the Edit Series field

Finish Editing Legend Entries (Series)

                   

                               

         

Select OK

Begin Defining Horizontal (Category) Axis Labels

                   

                               

         

Click on Edit in the Horizontal (Category) Axis Labels pane

Select Horizontal Axis Range

                   

                               

         

1. Select the Product Name range by including the cells in the rows containing the level opening and closing tags along with the cell containing the <ProductName> tag
2. Confirm the selection by clicking on the icon at the right end of the Axis Labels field

Confirm Horizontal Axis Range

                   

                               

         

Click on OK

Conclude Chart Creation

                   

                               

         

Click on OK

Generate Preview

                   

                               

         

Select preferred Preview output format (eg .xlsx).

View Preview

                   

                               

         

The Excel chart is visible on the upper left corner.

Call up Save Dialog

                   

                               

         

Select the Save As icon

Save Template

                   

                               

         

1. Insert "Excel Chart Report template.xlsx" as File name
2. Select .xlsx as type of Excel Workbook
3. Click on Save