Ad-hoc to excel

[#1]

Hi,

Is there any way to automatically save Ad-hoc reports into excel.

Thanks.

[Gysbert_Wassenaar]

Depends by what you mean by report. Is that a Qlikview chart object or a Qlikview report object? You can right click a chart object and export it to excel. That's not possible with reports. Those can only be printed or output to pdf.

[Mark_Little]

Hi Bob,

Could be worth looking into Nprinting, if your going to be doing it a lot.

Mark

[#4]

Hi Gysbert,

I want to export pivot table to excel automatically everyday. Nprinting is a good option but, since this is for a limited time, looking for another way.

[Gysbert_Wassenaar]

Well, you can try mucking about with batch scripts and macro's. There are probably some examples you can find on this site.

[Anonymous · Accepted solution]

Hi Bob,

If you can do your design on a pivot table, you can export it to Excel with same format. But, if you want more designed with combined columns, you can do it with NPrinting or with Macro.

See this: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Regards!