For this example, we will use the Qlik Reporting connector and Microsoft SharePoint as the cloud storage tool.
For this approach, you will need a Qlik Sense app configured in your tenant that has public sheets available, a field with unique values for which the reports will be generated, and a Microsoft SharePoint destination path to store your reports.
To support this use case, we created a basic template featured below. This template example is also available as an attachment.
This template will loop over all unique field values in the specified app. For each value, it will generate a report of all public sheets with a selection based on the specific value. Each generated report will then be saved as a PDF file in SharePoint.
Of course, this is just a basic implementation. This template can be upgraded to suit other scenarios. Let's go over a few examples:
You can select a different destination connector for the cloud storage in the Copy File block;
You can replace the could storage block with the Send Mail block from the Mail connector to send the report as an attachment.
You can send an alert to a messaging system such as Microsoft Teams or Slack.
You can change the sheets mode to custom in the Create Report block and use the Add sheet to report block to further customize your reports.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.