Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
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.
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
If is is single simple table you can store the same in xls while loading.
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?