Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Export to Excel

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.

4 Replies
rittermd
Honored Contributor

Re: Export to Excel

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.

Not applicable

Re: Export to Excel

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

rittermd
Honored Contributor

Re: Export to Excel

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.

Not applicable

Re: Export to Excel

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