Skip to main content

Announcements
Week 3: High-Volume Iceberg Ingestion and Smarter Data Prep - WATCH NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
neetu_singh
Partner - Creator III

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

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.