topic Export Charts (Tables/Graphs) into Folder - as .jpeg in QlikView

Export Charts (Tables/Graphs) into Folder - as .jpeg

guytzumer — Thu, 20 May 2010 12:20:51 GMT

Hallo Qommunity

I need to Export Tables/Graphs into folder (in jpeg format) on the scheduled reload

Does anybody have a macro or exmple to export Charts (Tables/Graphs) into folder as .Jpeg file ??

Thanks in advance

Guy.

Export Charts (Tables/Graphs) into Folder - as .jpeg

guytzumer — Sun, 23 May 2010 08:25:53 GMT

Well, find the solution for that problam

it was pretty easy

this example is for export a Sheet & a Graph

to make it over night running - jest to tie it to "OnPostReload"

sub exportToFolder

GraphPath = "C:\qlikview\"

ActiveDocument.Sheets("Main").ExportBitmapToFile GraphPath & "A.jpg"

ActiveDocument.GetSheetObject( "CH01").ExportBitmapToFile GraphPath & "B.jpg"

ActiveDocument.GetSheetObject( "CH02").ExportBitmapToFile GraphPath & "C.jpg"

end sub

Guy

Export Charts (Tables/Graphs) into Folder - as .jpeg

jagannalla — Tue, 25 Oct 2011 05:21:04 GMT

Hi,

Whether this code works at access point. Write now i don't have test machine to test this code in webview.

Re: Export Charts (Tables/Graphs) into Folder - as .jpeg

monika_armonika — Fri, 25 Jan 2019 16:36:45 GMT

The macro runs for me but the folder stays empty. I have created a button and I am able to push it, mouse arrow becomes a turning wheel for a bit etc.

Steps: I have allowed system access in edit Module.

I have verified the correct id of the graph

I have created the folder where the graph should be saved. Is it possible that I have a problem in my settings? QlikView version: 12.10. Microsoft office (if relevant): 365.

I would really appreciate your help.