Export to Excel

[#1]

Hi, I am looking for a way to export all charts to multiple excel sheets as so:

Sheet 1: Charts (images)
Sheet 2: Chart Values
Sheet 3: Raw Data for selected period.

How would I be able to do this?

Thanks.

[rittermd]

If you right click on a chart you can choose Export Data.  That will export that data to excel.

You would have to do this for each object on your sheet.

[#3]

Yes, I have been doing it manually, but I am looking for an automatic way of exporting all to excel

[rittermd]

Unless someone has come up with an extension in Qlik Branch then I don't believe there is a way to do what you want.

You can only export the entire sheet to PDF.

[#5]

You can actually build a macro to loop through the charts and export, I just don't know enough to build it myself.

Here is an example of one:

sub launchXL

set oXL=CreateObject("Excel.Application")

oXL.visible=True

oXL.Workbooks.Add

aSheetObj=Array("CH05","CH01")

for i=0 to UBound(aSheetObj)

oXL.Sheets.Add  

Set oSH = oXL.ActiveSheet

oSH.Range("A1").Select   

Set obj = ActiveDocument.GetSheetObject(aSheetObj(i))

obj.CopyTableToClipboard True

oSH.Paste

sCaption=obj.GetCaption.Name.v

set obj=Nothing    

oSH.Rows("1:1").Select

oXL.Selection.Font.Bold = True      

oSH.Cells.Select

oXL.Selection.Columns.AutoFit

oSH.Range("A1").Select    

oSH.Name=left(sCaption,30)  

set oSH=Nothing 

next

set oXL=Nothing

end sub