topic Re: Export pivot table to excel file with multiple sheets in Qlik Automate

Export pivot table to excel file with multiple sheets

StefanoC — Mon, 03 Apr 2023 09:26:46 GMT

Hi all, I would like to know if it is possible to export a pivot table in a single excel file on multiple sheets based on a field (saas environment). Thanks in advance

Re: Export pivot table to excel file with multiple sheets

AfeefaTk — Tue, 04 Apr 2023 05:49:07 GMT

Hi @StefanoC

Currently, it's not possible to get pivot table data using the Qlik Cloud Services connector in QAA.

You can get straight table data using the "Get Straight Table Data" block.

We can export the sheet as a Pdf/PowerPoint report using Qlik Reporting connector blocks.

There are a lot of templates already available in QAA which can be used to export reports.

You can find it by navigating to Add new -> New automation -> Categories -> Reporting.

Will that work for you?

Thanks

Re: Export pivot table to excel file with multiple sheets

StefanoC — Tue, 04 Apr 2023 10:21:24 GMT

Hi @AfeefaTk , thanks for the reply; I have seen the other templates but unfortunately they are not useful for what we would need. Kind Regards Stefano

Re: Export pivot table to excel file with multiple sheets

AfeefaTk — Tue, 04 Apr 2023 10:25:04 GMT

Hi @StefanoC

Sorry for not being of much help.

I would suggest you add this feature request via ideation if you want the blocks to be in the Qlik Cloud Services connector in QAA.

https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Thanks

Re: Export pivot table to excel file with multiple sheets

AfeefaTk — Tue, 04 Apr 2023 10:53:58 GMT

Hi @StefanoC

Just wanted to let you know that we have Excel reporting blocks to be added to the Qlik Reporting Connector in our roadmap and that could hopefully cover your use case.

Thanks

Re: Export pivot table to excel file with multiple sheets

StefanoC — Thu, 06 Apr 2023 08:22:27 GMT

Hi @AfeefaTk , many thanks for the replies.

Kind Regards,

Stefano