https://community.qlik.com/t5/Qlik-Automate/Get-Data-from-a-Pivot-Table/m-p/2521985#M5985 <P>Hello, we have an app with a pivot table that contains monthly values across multiple years, so when the columns are expanded, we have a two-level header. The top-level is the year and the bottom-level is the month. We'd like to use an Automation to extract data from this pivot table and put it into an Excel spreadsheet. Which block should we use to get data from a pivot table?</P> Mon, 23 Jun 2025 15:51:49 GMT skustes 2025-06-23T15:51:49Z https://community.qlik.com/t5/Qlik-Automate/Get-Data-from-a-Pivot-Table/m-p/2521985#M5985 <P>Hello, we have an app with a pivot table that contains monthly values across multiple years, so when the columns are expanded, we have a two-level header. The top-level is the year and the bottom-level is the month. We'd like to use an Automation to extract data from this pivot table and put it into an Excel spreadsheet. Which block should we use to get data from a pivot table?</P> Mon, 23 Jun 2025 15:51:49 GMT https://community.qlik.com/t5/Qlik-Automate/Get-Data-from-a-Pivot-Table/m-p/2521985#M5985 skustes 2025-06-23T15:51:49Z https://community.qlik.com/t5/Qlik-Automate/Get-Data-from-a-Pivot-Table/m-p/2522191#M5988 <P>Hi ,&nbsp;</P><P>I am not sure if this is possible using Qlik Automation. But, it's definitely possible using Qlik Reporting using Excel Add-in.</P><P>Check the link&nbsp;<A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/add-in-excel-get-started.htm" target="_self">Reporting-add-in-excel</A>&nbsp;</P><P>Thanks.</P><P>Vikram</P> Tue, 24 Jun 2025 16:27:02 GMT https://community.qlik.com/t5/Qlik-Automate/Get-Data-from-a-Pivot-Table/m-p/2522191#M5988 vkramBI4Qlik 2025-06-24T16:27:02Z