topic Pivot table export to Excel in QlikView

Pivot table export to Excel

Wed, 19 Jan 2011 11:22:48 GMT

Hi, I am trying to export a pivot table into Excel from QlikView, is there a way to automatically display the data as a pivot table (same way how it looks in QlikView) that could potentially save user to create another pivot in Excel.

Pivot table export to Excel

suniljain — Wed, 19 Jan 2011 12:49:24 GMT

pls write following macro.

set obj = ActiveDocument.GetSheetObject("CH703")
obj.ExportEx "E:\Qlikview\Department_Loadinng.xls",5

Pivot table export to Excel

Wed, 19 Jan 2011 12:59:32 GMT

Thanks for the quick response. Where do I write this macro?

Pivot table export to Excel

amars — Wed, 19 Jan 2011 13:04:01 GMT

Hi,

I don't feel that there is any way for putting Qlikview PIVOT into excel pivot but u can Right click the chart select Copy To Clipboard -> Full Table & paste it in excel & u can see all the values grouped in a cell. For doing it through macro.

set XLApp = CreateObject("Excel.Application")
XLApp.Visible = FALSE
set XLDoc = XLApp.Workbooks.Add

XLDoc.Sheets(1).name = "Supervisor Report"
set XLSheet = XLDoc.Worksheets(1)
set MyTable = ActiveDocument.GetSheetObject("CH550")
set XLSheet = XLDoc.Worksheets(1)
MyTable.CopyTableToClipboard true
XLSheet.Paste XLSheet.Range("B10")
XLDoc.SaveAs "C:\QlikView\Reports\" & strFileName & ".xlsx"

XLApp.Visible = False
XLApp.Quit
Set XLApp = Nothing
Set Table = Nothing

Thanks.

Pivot table export to Excel

Wed, 19 Jan 2011 13:10:33 GMT

Thanks for this. Where do I write this Macro. Can I assign a button to this so that the users can export it straight into Excel ?

Pivot table export to Excel

Wed, 19 Jan 2011 13:32:12 GMT

Hi,

Any one can pls Explain which action we can use to run this macro?

Thanks,

vivek

Pivot table export to Excel

Wed, 19 Jan 2011 14:46:49 GMT

Hi, I am getting an error message "

ActiveX component can't create object: 'Excel.Application'

Pivot table export to Excel

suniljain — Thu, 20 Jan 2011 06:53:07 GMT

reason behind this error is that MS office is not installed where you are running qlikview.

Pivot table export to Excel

Mon, 11 Jul 2011 15:50:32 GMT

how do you fix this without having to reinstall MS office in differ location

Pivot table export to Excel

Mon, 11 Jul 2011 17:02:48 GMT

in the macro windows (where you created it ) you have to set the permissions to system access and allows system access ( at the bottom left of the screen).

Philippe

Pivot table export to Excel

Mon, 11 Jul 2011 17:04:40 GMT

the Action is External and then Run Macro

Philippe

Re: Pivot table export to Excel

Tue, 03 Jun 2014 04:58:13 GMT

will this work in any browser?.. We have problem in using macro