Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to schedule export to excel pivot table

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

Tags (3)
1 Solution

Accepted Solutions
VishalWaghole
Not applicable

Re: how to schedule export to excel pivot table

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

4 Replies
VishalWaghole
Not applicable

Re: how to schedule export to excel pivot table

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

Not applicable

Re: how to schedule export to excel pivot table

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
Not applicable

Re: how to schedule export to excel pivot table

Hi,

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

Regards

ASHFAQ

Not applicable

Re: how to schedule export to excel pivot table

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