Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
neetu_singh
Partner
Partner

Required Extension object to export pivot table data into csv/excel after reload in qlikview

Hi All,

I need an extension object in qlikview to export pivot report data into csv/excel after the refresh complete.

I am able to achieve this using macro but can't use macro so need an extension object for that.

Please help.

Working macro is mention below-

SUB ExportChartToCSV
SET v = ActiveDocument.Variables("vExport_Date")
varDate = v.GetContent.STRING
     SET  objChart = ActiveDocument.GetSheetObject("CH386")
     objChart.Export "filepath\data_"&varDate&".CSV", ", "
END SUB

 

 Thanks in advance.

 

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

Assuming you can change the script have you thought of using statements at the end of your script to create the pivoted data in a table & then store this out and drop the table.

Appreciate this is not straight forward if your model has lots of tables/the columns pivoted vary in number, but unless someone has already written an extension that does this is possibly an easier ask.

Cheers,

Chris.