topic Re: Export to Excel button in QlikView

Export to Excel button

Gopi_E — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlikers,

I need a button to export particular object or table to excel. is there any way to create button to export excel.

Thanks in advance for your support.

Regards,

Gopi

Re: Export to Excel button

qlikwiz123 — Wed, 05 Feb 2020 17:49:49 GMT

Maybe create a button, then add Action as follow?

Add a button -> Actions -> Export -> Setup

Then choose the fields you'd like to export and specify File and Format

Re: Export to Excel button

Gopi_E — Thu, 06 Feb 2020 06:13:26 GMT

Hi Qlikwiz123,

Thanks for your reply,

we need to export object, as you said we are unable to setup to export particular object, and the export action after export its exporting combined fields. I have tried with macro its worked as we want, but this macro not working in web view.

can you please tell me is there any way to do this.

Thanks in advance

Re: Export to Excel button

MikeW — Thu, 06 Feb 2020 06:27:01 GMT

Yes, you should be able to use javascript and sheetjs as well. I assume by object you mean a pivot chart or a straight table and not some graphs or pictures.

Re: Export to Excel button

Brett_Bleess — Wed, 04 Mar 2020 20:16:38 GMT

I suspect you are using the wrong API for the Export, which is why Ajax is not working, everything is going to run server-side, but I know there is an export API that will run things client-side, believe it is ServerSideExportEx, you will find the QVW with all the APIs in the following link:

QlikView API QVW

Regards,
Brett