topic Ad-hoc to excel in QlikView

Ad-hoc to excel

Thu, 11 Aug 2016 07:21:30 GMT

Hi,

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

Thanks.

Re: Ad-hoc to excel

Gysbert_Wassenaar — Thu, 11 Aug 2016 08:48:52 GMT

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.

Re: Ad-hoc to excel

Mark_Little — Thu, 11 Aug 2016 08:55:35 GMT

Hi Bob,

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

Mark

Re: Ad-hoc to excel

Fri, 12 Aug 2016 01:46:57 GMT

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.

Re: Ad-hoc to excel

Gysbert_Wassenaar — Fri, 12 Aug 2016 07:51:21 GMT

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

Re: Ad-hoc to excel

Anonymous — Fri, 12 Aug 2016 07:58:00 GMT

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!