Discussion board where members can get started with Qlik Sense.
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?
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.
Yes, I have been doing it manually, but I am looking for an automatic way of exporting all 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.
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:
for i=0 to UBound(aSheetObj)
Set oSH = oXL.ActiveSheet
Set obj = ActiveDocument.GetSheetObject(aSheetObj(i))
oXL.Selection.Font.Bold = True