Skip to main content

PowerPoint Report

This section will create a PowerPoint report using Qlik Sense objects.

To create a PowerPoint report, go to the Reports tab and click Create report button.

  1. Give a name to your report
  2. Add a description if you wish (optional)
  3. In the Type drop-down menu, select PowerPoint
  4. Select a project
  5. Click Save

You will be redirected to the report Overview tab. In the Template field, click the Edit button. A PowerPoint file will be downloaded.

  1. Open the PowerPoint file

  2. The Qalyptus Cloud Office add-in will automatically open in the task pane. If you use Office for the web, click the add-in icon to open it.

  3. The Apps tab lists all your Qlik Sense apps. You can select one or more apps to use to create the report. After choosing an app, click on the three-point button to refresh its metadata (variables, objects, and fields)

  4. The Variables tab lists the Qlik variables of the selected apps. Select the ones you want to use

  5. The Objects tab lists the Tables, Charts, and Master Items of the selected apps. Select the ones you want to use

  6. The Overview tab shows selected objects and variables to use in your template

  7. The Save button allows you to save the template file

  8. The Preview button allows you to have a preview of the report

    Qalyptus Cloud add-in overview

Add objects to create the template​

Let's create a simple template using a chart, a table, and a variable.

  1. Select the Apps tab and choose a Qlik Sense app
  2. In the Variables tab, right-click on a variable and select Add variable
  3. In the Objects tab, find the chart you want to use, right-click, and choose Use object as an image. Find the object table you wish to use, right-click, and select Use ** object as table**
  4. Select the Overview tab to insert the object into the file
  5. Under the Variables node, right-click on the variable previously added and choose Insert
  6. Under the Table node, right-click on the table object previously added, select Copy object or Copy columns, then paste it in the place of your choice. The first option will use the whole object, which will be exported as it is in Qlik Sense? The second one will allow you to format each column of the table using the PowerPoint features
  7. Under the Image node, right-click on the chart previously added and select Insert
  8. You can use all the PowerPoint features to format the file: resize the chart image, format the table columns, add additional text and images, etc.
  9. Click Preview to see the result
  10. Click Save to save the file. You can close the file and back to Qalyptus Cloud