how to schedule export to excel pivot table

[#1]

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

[VishalWaghole · Accepted solution]

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

[#3]

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

[ashfaq_haseeb]

Hi,

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

Regards

ASHFAQ

[#5]

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