topic Re: how to schedule export to excel pivot table in QlikView

how to schedule export to excel pivot table

Wed, 09 Jul 2014 07:32:08 GMT

I would like to schedule export to excel pivot table. In the pivot table I created Expressions (Calculated Formula) that there are NOT in

the table Qlik (or should play). I'm forced to write a macro? with vba code?

thank in advance

Ettore

Re: how to schedule export to excel pivot table

VishalWaghole — Wed, 09 Jul 2014 07:38:24 GMT

Hi,

To export pivot table in to excel, Qlikview has inbuilt functionality.

Please refer this image.

To enable this, you need to go to property, under caption tab you will find "Send to Excel" option.

-- Regards,

Vishal Waghole

Re: how to schedule export to excel pivot table

Wed, 09 Jul 2014 14:12:16 GMT

Thank you, your claim is correct.

but I would like to schedule this export not manually but automatically. I have to create a macro?

the report is refreshed from a night schedule, and I would like to generate excel at the time of the update. I would not open the document and manually export

Thank in advance

Ettore

Re: how to schedule export to excel pivot table

ashfaq_haseeb — Wed, 09 Jul 2014 14:14:38 GMT

Hi,

If is is single simple table you can store the same in xls while loading.

Regards

ASHFAQ

Re: how to schedule export to excel pivot table

Wed, 09 Jul 2014 14:39:00 GMT

Thank you,

but In the pivot table I created Expressions (Calculated Formula) that there are NOT in

the table Qlik (or should play). if I export the table i NOT export expressions.

I'm forced to write a macro? with vba code?

thank in advance

Ettore