Excel tables

You can populate Excel tables with data from QlikView and Qlik Sense objects so that you can apply Excel table functions. For example, you can apply Excel formatting rules.

You can use the entire QlikView or Qlik Sense table or select specific columns.

Create a Excel report template

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 table.
  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 Tables node, and then select Add objects.
  8. Select CH184 from the objects list.
  9. Click OK.
  10. Right-click CH184, and then select Properties.
  11. Clear the Keep Source Formats check box.

    This will remove QlikView formatting from the report table so that you can customize it.

  12. Set Show Headers to Show above tag cell for the columns of the table.
  13. Hide: Qlik NPrinting will not add headers. You can type them, or obtain dynamic headers using QlikView variables and Excel formulas.

    Show in tag cell: column headers will be inserted in the tag cells and data will start in the row below. Formulas and variables in original QlikView headers will not be replaced.

    Show above tag cell: column headers will be inserted in the row above tag cells. Data will start on the row with the tags. Use this option when column headers in the original QlikView documents use variables or formulas and you want them to be reported in the table.

  14. Drag and drop the CH184 token into cell B2.
  15. Select the cell containing the <CH184> tag, if it is not already selected.
  16. Open the Excel Ribbonby clicking on the Toolbar icon in the View group of the Template Editor toolbar.
  17. Select the Insert tab on the Ribbon.
  18. Click the Table icon in the Tables group.

    The Excel table will be automatically expanded during the generation of the report to include all rows and columns.

  19. Column widths can be set independently.

  20. Apply table styles from the Design tab of Table Tools in the Ribbon.
    • Font and alignment formatting applied from the Ribbon to the heading cell will be applied to all table cells in the heading row.
    • Font and alignment formatting applied from the Ribbon to the content cell will be applied to all table cells in the content rows.
    • Number formatting will have no effect.
  21. Click Preview to preview the table.

Customize properties

Do the following:

  1. Add CH184 to the Tables node again, resulting in the CH184_1 node.
  2. Clear the Keep Source Formats check box.
  3. Set Show Headers to Hide.
  4. Expand the CH184_1 node, and then drag and drop some columns one-by-one in the template into empty cells.

Create table

Do the following:

  1. Select the horizontally contiguous cells with tags.
  2. Click the Table icon in the Tables group to open the Create Table dialog.
  3. Click OK.
  4. Format the table.
    • Font and alignment formatting applied from the Ribbon to the heading cell will be applied to all table cells in the heading row.
    • Font and alignment formatting applied from the Ribbon to the content cell will be applied to all table cells in the content rows.
    • Number formatting will have no effect.

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?