Pivot table export to Excel

[#1]

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.

[suniljain · Accepted solution]

pls write following macro.

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

[#3]

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

[amars]

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.

[#5]

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 ?

[#6]

Hi,

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

Thanks,

vivek

[#7]

Hi, I am getting an error message "

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

[suniljain]

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

[#9]

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

[#10]

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