Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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

 

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Contributor
Contributor

Could I call this Export procedure from load script.

Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand
Highlighted
Contributor
Contributor

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?