Get Data from a Pivot Table

[skustes]

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?

[vkramBI4Qlik · Accepted solution]

Hi , 

I am not sure if this is possible using Qlik Automation. But, it's definitely possible using Qlik Reporting using Excel Add-in.

Check the link Reporting-add-in-excel 

Thanks.

Vikram