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.
Working macro is mention below-
SET v = ActiveDocument.Variables("vExport_Date")
varDate = v.GetContent.STRING
SET objChart = ActiveDocument.GetSheetObject("CH386")
objChart.Export "filepath\data_"&varDate&".CSV", ", "
Thanks in advance.