Reporting from Qlik Cloud Analytics with Qlik Application Automation

You can create automated multi-page reports based on a Qlik Sense app using Qlik Application Automation and the Qlik Reporting Service. Recipients can receive complex, scheduled reports, even if they do not have access to Qlik Cloud Analytics. Get started with a report template, or create a fully custom automation. Reports can be in PDF or PowerPoint format.

You can also integrate the Qlik Reporting Service API into your own enterprise systems. For more information about the API, see Developer Portal for Qlik Cloud.

When to use it

Use the Qlik Reporting Service and Qlik Application Automation when you need to:

• Deliver bursted, multi-page reports.

• Deliver reports to external recipients, or internal recipients who cannot access Qlik Cloud Analytics.

• Create looping reports: a page within a report, looping over dimension values.

• Create a report based on multiple Qlik Cloud apps.

Report automations can be simple, such as a PDF where each page is a sheet from the Qlik Sense app. They can also be very complex. For example:

• A daily PowerPoint report where each page shows a different supply item that is running low, and should be re-ordered.

• A cycled report that goes out to all regional managers. Each manager only sees information relevant to their region. The recipient list is imported from Microsoft Office 365.

• A report that uses levels to create a month > category hierarchy to generate a report with sales for each product category for each month.

Other ways to share data insights

In addition to generating reports with Qlik Application Automation, you can configure and generate reports from your Qlik Cloud Analytics app using tabular reporting. Output from tabular reports can be in Microsoft Excel or PDF format. Create a report template using the Qlik add-in for Microsoft Excel, and upload it into the Reporting section of your app (located in the Prepare tab). Create report tasks to control the distribution of the report output, employing filters to generate individualized output for report recipients. For more information about tabular reporting, see Tabular reporting with Qlik Cloud Analytics.

If you want to receive notifications when certain conditions are met in your data, see Monitoring data with alerts. Alerts are evaluated based on data reloads and are sent based on data exceptions. Alerts can also trigger on a schedule, but you still need to create a condition or target to save an alert. You can add Qlik Sense users to an alert.

If you want to receive regular updates about a single chart or sheet based solely on a schedule, you can create a subscription. For more information, see Scheduling reports with subscriptions. You can add Qlik Cloud users to a subscription.

Security

Once a report is created using an automation, you can share the document with anyone. This means you could potentially share data from an app that recipients in your Qlik Cloud system do not have permission to view. Or you might be sharing data with people outside your Qlik Cloud system.

Report overview

Features

You can create automated reports using the Qlik Reporting connector included with Qlik Application Automation. A report automation can be connected to multiple Qlik Sense apps. Your automation can access everything in the app, including charts, data, selections, fields, and variables. You can customize the report by applying different selections to specific sheets, or by configuring sheets to show alternate states.

Qlik Cloud Analytics provides report templates that can be customized and re-used. If your reports are distributed as PowerPoint files, they can be edited by your recipients.

Your reports can have a dynamic name based on fields or variables. For example, a daily report can have the date it was generated as part of the name.

Access

You can only make a report automation with Qlik Sense apps you have permission to access. Report automations are saved in your personal space.

Recipients

Your recipients do not need to have a Qlik Cloud user account. You can add recipients in several ways:

• manually

• table or data source in the Qlik Sense app

• Microsoft Office 365 file

• Amazon S3 file

• spreadsheet

• database

Distribution

The report is generated as a PDF or PowerPoint document. Reports can be generated on a schedule or based on a trigger.

Reports can be delivered to email or Qlik Application Automation cloud storage connectors. External email clients often enforce size limits for email attachments. Check with your SMTP provider to find out what your limit is. Reports delivered using cloud connectors have no file size limit.

The following connectors are available:

• Amazon S3

• Dropbox

• FTP

• Google Cloud Storage

• SFTP

For more information, see Connector blocks.