Importing cell values from QlikView objects

You can use any cell value or group of cell values from QlikView or Qlik Sense objects in your Excel, Word, PowerPoint, HTML, or PixelPerfect reports. Cells work in the same way for all reports.

Cells are imported into Qlik NPrinting report cells from documents based on their position. For example, you can import the cell that is in the third column of the first row of CH123.

If you change something in the original object, Qlik NPrinting will always import the cell into the original position. For example, if you switch column 2 and column 3, Qlik NPrinting still imports the cell from column 3, which now contains different data. Cells work on a positional basis and cannot follow changes in the source objects. These have to be managed.

Note: You can use Excel formatting tools to apply custom formats to the cells with the Keep Source Format option deselected. You can also re-build a object cell-by-cell, or part of it, and add Excel formulas to calculations.

Create new Excel report

Do the following:

  1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
  2. Enter a Title for the report.Excel cells report.
  3. Select Excel from the Type drop-down list.
  4. Select an app from the App drop-down list.
  5. Click Create to create the report.
  6. Click Edit template to open the Template Editor.
  7. Right-click the Cells node, and then select Add Cells.
  8. Select the browse icon to the right of the Object field.
  9. Select the Connection to the QlikView document that contains the object you want.
  10. Select CH184.
  11. Click OK.

Specify Cell

Do the following:

  1. Enter the number 1 in the Top Row field.

    Notice that the Bottom Row field now also contains the number 1. The fact that they contain the same number means that you are selecting cells from only one row. Row 0 is the row of QlikView object titles, so row 1 is the first data row.

  2. Enter the number 1 in the Left Column field.

    Notice that the Right Column field now also contains the number 1. The fact that they contain the same number means that you are selecting cells from only one column. Column 0 is the first column on the left of the source QlikView object.

  3. Keep the Keep Source Formats box selected.
  4. Click OK.
  5. Repeat the three previous steps, but this time clear the Keep Source Formats box.
  6. Repeat the previous step, but this time add the format code "$ #,##0.00" to the Format field. Then do it once more, but leave out the Format code because you are going to use Excel formatting tools to format the cell containing this last imported cell value.

After executing these step you will have:

  • From steps 1-3: one cell with the source formats.
  • From step 5: one cell without the source formats.
  • From step 6: one cell without the source formats, and the custom format "$ #,##0.00" applied by Qlik NPrinting.

Look at the cells in the final report to compare the effects of different formatting options.

You can customize the name and the description during the connection of each cell. The first number after the name indicates the cell row. The second number indicates the cell column.

Embed cell values in template

Do the following:

Drag the cell value node tokens into the template, and then drop them onto an empty cell one at a time.

Preview and save

Do the following:

  1. Click Preview.
  2. Check the report, close it, and then edit the template again if necessary.
  3. Click Save and Close to save the template and close the Template Editor.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?