Reporting through Automation

[sumitk]

In Qlik Sense, I have a sheet containing a Filter Pane with a Region field and a Straight Table displaying data based on the selected Region.

The Region filter contains three values:

• Region 1
• Region 2
• Region 3

I need to create an Excel report using Qlik Automation with the following requirements:

1. Only one Excel workbook should be generated.
2. The workbook should contain three separate sheets:
   • Region 1
   • Region 2
   • Region 3
3. Each sheet should contain only the data from the Straight Table corresponding to that particular Region.
4. The automation should dynamically apply each Region as a filter, retrieve the filtered Straight Table data, and write it to the respective Excel sheet.

Question: What Qlik Automation blocks and configuration should be used to achieve this requirement?

[Frank_S]

Creating a report using Qlik Automate | Qlik Cloud Help
This link demonstrates the fundamentals of your requirement.

Hope it helps...

[sumitk]

Can you please share the exact article for this problem statement.