Export pivot table to excel file with multiple sheets

[StefanoC]

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

[AfeefaTk]

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

[StefanoC]

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

[AfeefaTk]

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

[AfeefaTk]

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

[StefanoC]

Hi @AfeefaTk , many thanks for the replies. 

Kind Regards,

Stefano