Skip to main content

Importing QlikView and Qlik Sense cell values

ON THIS PAGE

Importing QlikView and Qlik Sense cell values

You can use any cell value or group of cell values from QlikView or Qlik Sense objects in Excel, Word, PowerPoint, HTML, or PixelPerfect reports.

Overview

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

In QlikView connections, cell #1 selects the value from the total row (at the top). In Qlik Sense connections, cell #1 selects the first value of the table (excluding the total row).

If you change something in the original app or document, you will have to update your Qlik NPrinting report template. Cells work on a positional basis and cannot follow changes in the source objects. These have to be managed. For example, Qlik NPrinting will not automatically update cell nodes if you switch column 2 and column 3 in Qlik Sense.

Note: You can use Excel formatting tools to apply custom formats to cells if you clear Keep Source Formats in the Properties pane. You can also re-build a object cell-by-cell, or part of it, and add Excel formulas to calculations.

Inserting cell values into an Excel report

The following example shows how to insert QlikView cell values into an Excel report template. You will insert the same chart object with the same cell position four times, but with different formatting.

Specifying cells from a QlikView document

Do the following:

  1. Open an existing Excel report template, or create a new one.
  2. Create a new cell:
    1. In the left-hand pane, right-click the Cells node, and select Add cells. A new window opens.

    2. Click the browse icon ... to the right of the Object field.
    3. Select a chart object from the list. Click OK.
    4. Qlik NPrinting automatically fills the Name field. The first number after the name indicates the cell row. The second number indicates the cell column. You can change the name if needed.

    5. The Description field is optional.
    6. In the Top Row field, enter the number 1 .

      If the Bottom Row field now also contains the number 1: 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.

    7. In the Left Column field, enter the number 1 .

      If the Right Column field now also contains the number 1: you are selecting cells from only one column. Column 0 is the first column on the left of the source QlikView object.

    8. Keep the Keep Source Formats box selected. Click OK.
  3. Repeat steps a-g. Clear the Keep Source Formats box.
  4. Repeat steps a-g. Clear the Keep Source Formats box and add the format code "$ #,##0.00" to the Format field.
  5. Repeat steps a-g. Clear the Keep Source Formats box. You will use Excel formatting tools to format the cell containing this cell value.

Adding the cell values to the template

Do the following:

  1. Drag each cell value node token onto an empty cell in the template.
  2. Format the fourth cell value you created using Excel formatting options.

    For example: change the font size and color.

  3. Click Preview. You will see the same cell value formatted four ways:

    1. A cell formatted the same as the original document.
    2. A cell with no formatting.
    3. A cell with the custom format "$ #,##0.00" applied by Qlik NPrinting.
    4. A cell with custom Excel formats applied by you.
  4. Close the preview. You can continue to edit the template if necessary.
  5. Click Save and Close to save the template and close the Template Editor.