Exporting Pivot table object to .csv after re-load?

[Anonymous]

Question:  

I am trying Exporting Pivot table object to .csv after re-load

Which is working fine and creating .csv when I manually re-load but NOT exporting when reloaded on schedule overnight.

Any ideas on what to look for.

Sub ExportToCSV
'Export Sheet object data to CSV
MyDate = Replace(Date, "/", "-")
ActiveDocument.Sheets("SH02").Activate
set sObject = ActiveDocument.GetSheetObject("CH01")
sObject.Export "C:\Analytix\QVW\Transactiondata_" & MyDate & ".csv", ", " 
End Sub

 

[Gysbert_Wassenaar · Accepted solution]

The OnPostReload trigger only triggers when using Qlikview Desktop interactively. What you're trying to do cannot work if the Qlikview document is reloaded by Qlikview Server. Perhaps you can create the table you need in the script and store that in a csv file during the script execution.

[Anonymous]

Could I call this Export procedure from load script.

[Gysbert_Wassenaar]

Maybe, but it won't work because the pivot table does not exist during the execution of the script.

[Anonymous]

So what my choices to export an object output to .csv

1. create a table and save it save it as .csv

    there is logic in the pivot table object so not sure this good option for me.

2. is there any other way i can export .csv?