Use any cell value or group of cell values from QlikView objects in your Excel reports.
Create New Template
- Enter a meaningful Name for the report
- Select New in the Template section of the menu
Select Object to Import
- Select a Connection to the QlikView document containing the object you want to add, in this case, SalesDemo
- Select the Top 25 Products - CH184 object
- Click on OK
Specify Cell
- Enter the number one in the Top Row field. Notice that the Bottom Row field also contains the number one now. The fact that they contain the same number means that you are selecting cells from only one row.
- Enter the number one in the Left Column field. You will notice that the Right Column field also contains the number one now. The fact that they contain the same number means that you are selecting cells from only one column.
- The Keep Source Formats box is checked by default. Leave it so.
- Click on OK
Select Same Cell to Import
Repeat the three previous steps again but uncheck the Keep Source Formats box this time.
Select Same Cell to Import Twice Again
Repeat the previous step again but add the format code "$ #,##0.00" to the Format field this time. Then do it once more, but leave out the Format code because we are going to apply Excel format tools to the cell containing this last imported cell value.
Embed Cell Values in Template
- Drag the cell value node tokens into the template and drop them on an empty cell one at a time
- Format the cell containing Top 25 Products_1_1_3 with Excel formatting tools
- Click on Preview
Select New Source Object to Import Cells from
Switch to another Worksheet
- Chose the Product KPI - CH189 object
- Enter the number zero in the Top Row field
- Enter the number five in the Bottom Row field. This combination selects cells from rows zero (row 0 is the heading row) through row five
- Enter the number zero in the Left Column field
- Enter the number one in the Right Column field. This combination selects cells from the first two columns in the chart
- Uncheck the Keep Source Formats box
- Click on OK
Build Table
Drag each of the Cell node tokens into the template and drop them onto appropriate empty cells one by one. Note the progression of indices. Format to please. The last few cells have been embedded and formatted outside the scheme to show that they can be placed and formatted independently.
Comments