topic Re: Exporting Pivot table object to .csv after re-load? in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Gysbert_Wassenaar — Fri, 01 Jul 2016 15:54:51 GMT

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.

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

Anonymous — Fri, 01 Jul 2016 16:04:09 GMT

Could I call this Export procedure from load script.

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

Gysbert_Wassenaar — Fri, 01 Jul 2016 16:11:23 GMT

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

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

Anonymous — Fri, 01 Jul 2016 16:25:58 GMT

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?