topic Re: Schedule the export of a pivot table in QlikView

Schedule the export of a pivot table

Sat, 23 Jun 2012 21:53:42 GMT

Hi!

Can any one help me please ?

I have a qvw with a few tabs. There is one tab with a pivot table and a graphic.

My client has the need to export data from a pivot table to Excel, every month on a certain day and at a certain hour.

And the export shall be for a particular folder on pc.

Thaís in advance,

Sandra

Re: Schedule the export of a pivot table

deepakk — Sun, 24 Jun 2012 12:41:21 GMT

hi Sandra,

Attach is a sample file for exporting to excel using macro. You can schdule the file using in windows scheduler .

You can input the date of a month on which it should export the file.

A tigger has been set on the postreload method.

You can use publisher or software like Npriting to do this job.

Let me knw if you have any queries on the same.

Deepak

Re: Schedule the export of a pivot table

Wed, 27 Jun 2012 20:38:45 GMT

Hi Deepak,

You said "Attach is a sample file for exporting to excel using macro. " !?!

Can you be more Explicit, please. I never did such kind of requirements.

They don't have publisher or Nprinting.

Thanks once again.

Re: Schedule the export of a pivot table

deepakk — Thu, 28 Jun 2012 05:54:10 GMT

Ops.. I missed the file.

I have attched it in this post

Deepak

Re: Schedule the export of a pivot table

Anonymous — Wed, 19 Sep 2012 14:46:53 GMT

hi Deepak, quick question how can i schdule this report exporting on a regular basis. mean do i need to click on the Test button always when i wanted to export the data or else can i create a task in Publisher. Once the exporting is done where is the destionation the exported data will land. My requirement is to send the table information to Email. Please help me on this.

Re: Schedule the export of a pivot table

deepakk — Wed, 19 Sep 2012 18:01:29 GMT

hi vinay,

On post reload event , you can call this macro. but this will not work with server. You have to schedule you reload through batch file. You can set the path inside the macro where the excel file need to be saved.

Else you can use Nprinting which is a third party tool. It has some easy way of scheduling the reports to excel and pdf.

I had never tried with publisher. I have either use batch file load and then run the macro or I have used Nprinting

Deepak

Re: Schedule the export of a pivot table

Anonymous — Wed, 19 Sep 2012 18:05:40 GMT

This Nprinting tool is that a free ware tool or they charge us. If you have any details on that can you please share on that.

Re: Schedule the export of a pivot table

deepakk — Thu, 20 Sep 2012 05:46:27 GMT

It has a price attach to it. I have attach a sample document on nprinting.

If you want to know more about the pricing details. You can drop you mail id to my mail box.

deepak.dk@technoforte.co.in

Deepak