article QlikView App: Export Chart and Sheet to an Image File in Member Articles

article QlikView App: Export Chart and Sheet to an Image File in Member Articles https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/ta-p/1481124 <HTML><HEAD></HEAD><BODY><P>This example shows how to call a macro that saves image files for a selected sheet and chart to a specified location on reload.</P><P></P><P>The saved images could then be published via a web site or Wall Board, for example.</P><P></P><P>This QlikView was written in response to a post in the QlikView UK user group.</P><P></P><P>For other tutorial apps you can download and use, please see:</P><P><A href="https://www.quickintelligence.co.uk/qlikview-examples/" title="https://www.quickintelligence.co.uk/qlikview-examples/">https://www.quickintelligence.co.uk/qlikview-examples/</A></P><P></P><P>Hope you find this app useful.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Steve Dark</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><A class="jive-link-external-small" href="http://www.quickintelligence.co.uk/" style="color: #007fc0;">http://www.quickintelligence.co.uk/</A></P></BODY></HTML> Wed, 29 May 2013 21:55:54 GMT stevedark 2013-05-29T21:55:54Z QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/ta-p/1481124 <HTML><HEAD></HEAD><BODY><P>This example shows how to call a macro that saves image files for a selected sheet and chart to a specified location on reload.</P><P></P><P>The saved images could then be published via a web site or Wall Board, for example.</P><P></P><P>This QlikView was written in response to a post in the QlikView UK user group.</P><P></P><P>For other tutorial apps you can download and use, please see:</P><P><A href="https://www.quickintelligence.co.uk/qlikview-examples/" title="https://www.quickintelligence.co.uk/qlikview-examples/">https://www.quickintelligence.co.uk/qlikview-examples/</A></P><P></P><P>Hope you find this app useful.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Steve Dark</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><A class="jive-link-external-small" href="http://www.quickintelligence.co.uk/" style="color: #007fc0;">http://www.quickintelligence.co.uk/</A></P></BODY></HTML> Wed, 29 May 2013 21:55:54 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/ta-p/1481124 stevedark 2013-05-29T21:55:54Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481125#M1355 <HTML><HEAD></HEAD><BODY><P>Hi Steve,</P><P>thanks for the exmaple. I adapted your macro to my application.</P><P></P><P>I just ran into a new Problem: I want to export/save more Graphics, but the code always stops after 24 items.</P><P></P><P>Do you have an idea for this topic??</P><P></P><P>Would be great,</P></BODY></HTML> Wed, 04 Sep 2013 11:48:24 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481125#M1355 2013-09-04T11:48:24Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481126#M1356 <HTML><HEAD></HEAD><BODY><P>Hi Tobias,</P><P></P><P>Thanks for feeding back that this macro is working for you.  I've not hit that issue - but then I have not tried to export that many items.</P><P></P><P>Is the number of items variable - eg. if you export simpler items (eg. Text Areas) can you get more out?  This would imply some kind of time out.</P><P></P><P>Can you try creating multiple macros - perhaps one per sheet - and then firing each macro one after the other in a chain of Actions.  This may allow you to export all that you need to?</P><P></P><P>Hope that helps.</P><P>Steve</P></BODY></HTML> Wed, 04 Sep 2013 12:03:49 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481126#M1356 stevedark 2013-09-04T12:03:49Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481127#M1357 <HTML><HEAD></HEAD><BODY><P>The macro code used in this example is as follows:</P><P></P><P><STRONG>public function ExportImage</STRONG></P><P></P><P><STRONG>  ActiveDocument.GetApplication.WaitForIdle</STRONG></P><P></P><P><STRONG>  ActiveDocument.GetSheetByID("DASH").Activate</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>  vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String</STRONG></P><P><STRONG>  set obj = ActiveDocument.GetSheetByID("DASH")</STRONG></P><P><STRONG> </STRONG></P><P><STRONG> ActiveDocument.GetApplication.WaitForIdle</STRONG></P><P></P><P><STRONG>  fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"</STRONG></P><P></P><P><STRONG>  ActiveDocument.GetApplication.WaitForIdle</STRONG></P><P></P><P><STRONG>  obj.ExportBitmapToFile vFolder & fileName</STRONG></P><P><STRONG>  set obj = ActiveDocument.GetSheetObject("EXPORT")</STRONG></P><P><STRONG>  ActiveDocument.GetApplication.WaitForIdle</STRONG></P><P></P><P><STRONG>  fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"</STRONG></P><P></P><P><STRONG>  ActiveDocument.GetApplication.WaitForIdle</STRONG></P><P><STRONG>  obj.ExportBitmapToFile vFolder & fileName</STRONG></P><P><STRONG>end function</STRONG></P><P></P><P>You will need to modify the code to match the object name of the object which you wish to export.</P><P></P><P>Regards,</P><P>Steve</P><P></P><P><A class="jive-link-external-small" href="http://www.quickintelligence.co.uk/">http://www.quickintelligence.co.uk/</A></P></BODY></HTML> Thu, 05 Sep 2013 22:11:15 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481127#M1357 stevedark 2013-09-05T22:11:15Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481128#M1358 <HTML><HEAD></HEAD><BODY><P>Hi Steve,</P><P>i got it. As you suggested I split up the Code in pieces. It is more comfortable to adjust in case of changes in the document. now it works fine.</P><P>THanks again,</P><P>Tobias </P></BODY></HTML> Fri, 06 Sep 2013 05:31:34 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481128#M1358 2013-09-06T05:31:34Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481129#M1359 <HTML><HEAD></HEAD><BODY><P>No worries, glad it now works.</P><P></P><P>- Steve</P></BODY></HTML> Fri, 06 Sep 2013 07:49:18 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481129#M1359 stevedark 2013-09-06T07:49:18Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481130#M1360 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>while exporting image in mail body, i didn't get image outside border.</P><P>can u suggest how to get outside border of image in mail body....</P></BODY></HTML> Fri, 24 Jan 2014 13:25:32 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481130#M1360 csurajbhan 2014-01-24T13:25:32Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481131#M1361 <HTML><HEAD></HEAD><BODY><P>The missing border and (sometimes more of an issue) the caption of a chart happens whether you export the chart through the UI, copy and paste it or even pull it into a QlikView report.</P><P></P><P>If you need to get a border on there you could potentially post process the image with a graphics package that accepts a command line parameter.  This could then be called from the macro using a CMD function call?</P><P></P><P>What are you then pulling the image in to?  If it is going into a web page, for example, you could then put the border back on using HTML?</P><P></P><P>Hope that helps,</P><P>Steve</P></BODY></HTML> Mon, 27 Jan 2014 00:05:23 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481131#M1361 stevedark 2014-01-27T00:05:23Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481132#M1362 <HTML><HEAD></HEAD><BODY><P>thnx 4 d help...</P><P>but i got the solution in qlikview user prefe. setting itself....</P></BODY></HTML> Mon, 27 Jan 2014 13:29:36 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481132#M1362 csurajbhan 2014-01-27T13:29:36Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481133#M1363 <HTML><HEAD></HEAD><BODY><P>Sorry, I forgot that that had been added to the Export tab of the User</P><P>Preferences.  There was a time when this wasn't an option.</P><P></P><P>Glad you sorted it.</P><P></P><P>- Steve</P></BODY></HTML> Mon, 27 Jan 2014 14:14:13 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481133#M1363 stevedark 2014-01-27T14:14:13Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481134#M1364 <HTML><HEAD></HEAD><BODY><P>Steve</P><P>I found this to be very helpful, but was not sure if it was working until I examined the code.  As a result, I added a message box at the bottom of your code below.  Do you know if QlikView has automation/OLE links to print this example if you are not in the QlikView application?  Thanks again</P><P></P><P>public function ExportImage</P><P>    </P><P>    ActiveDocument.GetApplication.WaitForIdle</P><P>    </P><P>    ActiveDocument.GetSheetByID("DASH").Activate</P><P>    </P><P>    </P><P>    vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String</P><P>    </P><P>    set obj = ActiveDocument.GetSheetByID("DASH")</P><P>        </P><P>    ActiveDocument.GetApplication.WaitForIdle</P><P>    </P><P>    fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"</P><P>        </P><P>    ActiveDocument.GetApplication.WaitForIdle</P><P>    </P><P>    obj.ExportBitmapToFile vFolder & fileName</P><P></P><P>    set obj = ActiveDocument.GetSheetObject("EXPORT")</P><P>        </P><P>    ActiveDocument.GetApplication.WaitForIdle</P><P>    </P><P>    fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"</P><P>        </P><P>    ActiveDocument.GetApplication.WaitForIdle</P><P>    </P><P>    obj.ExportBitmapToFile vFolder & fileName</P><P>    message=msgbox(vFolder & fileName,0,"Export Image sent to...")</P><P>end function</P></BODY></HTML> Sat, 15 Mar 2014 13:14:17 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481134#M1364 richardouellett 2014-03-15T13:14:17Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481135#M1365 <HTML><HEAD></HEAD><BODY><P>Hi Richard,</P><P></P><P>I'm not sure I follow what your question is.  If you mean can you call the routine externally to QlikView and have it do the export, then the answer is kind of.  If you start QV.exe from a CMD window (or scheduled batch file, etc.) with a /r flag, the document will reload and the macro should fire.</P><P></P><P>You will need to be careful if you do this from Windows Scheduler though and you have a message box - as there message box will have nowhere to display.</P><P></P><P>Regards,<BR />Steve</P></BODY></HTML> Sat, 15 Mar 2014 23:22:38 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481135#M1365 stevedark 2014-03-15T23:22:38Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481136#M1366 <HTML><HEAD></HEAD><BODY><P>Steve</P><P>Thank you very much for this information!</P><P>Best</P><P>Rick</P></BODY></HTML> Sun, 16 Mar 2014 11:38:26 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481136#M1366 richardouellett 2014-03-16T11:38:26Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481137#M1367 <HTML><HEAD></HEAD><BODY><P>Thanks Steve for this code.  You mention in the qvw that it will not fire if called from QV server. Can you expand on that, and do you know of other ways to get it to execute after a reload from server?</P></BODY></HTML> Tue, 03 Jun 2014 20:23:18 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481137#M1367 2014-06-03T20:23:18Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481138#M1368 <HTML><HEAD></HEAD><BODY><P>When a document is refreshed from the QMC it does not fire the OnReload macro.  This means the above code would not work in this case.</P><P></P><P>Options you have are, refreshing that document from Windows Scheduler or using a tool like NPrinting to write out objects to files on a beat.  Let me know if you want more information on either of these options.</P><P></P><P>Another way I have used recently is to write out HTML from the reload, this works great for text based information and is very low impact.  See this blog post for more information:</P><P><A href="http://www.quickintelligence.co.uk/write-csv-qlikview-store/" title="http://www.quickintelligence.co.uk/write-csv-qlikview-store/">http://www.quickintelligence.co.uk/write-csv-qlikview-store/</A></P><P></P><P>Steve</P></BODY></HTML> Wed, 04 Jun 2014 06:44:35 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481138#M1368 stevedark 2014-06-04T06:44:35Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481139#M1369 <HTML><HEAD></HEAD><BODY><P>Hi Steve, sorry for my slow response.  I need some time to sort out what the business is lookking for..</P></BODY></HTML> Mon, 23 Jun 2014 18:37:37 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481139#M1369 2014-06-23T18:37:37Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481140#M1370 <HTML><HEAD></HEAD><BODY><P>I have Excel table and want to download that table into 'Excel with Logo'. Is it possible? I posted same question in different blog. Please help us if possible.</P><P></P><P>I posted the same in other blog as well..</P><P><A href="https://community.qlik.com/thread/143169">Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?</A></P></BODY></HTML> Sat, 22 Nov 2014 05:54:50 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481140#M1370 2014-11-22T05:54:50Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481141#M1371 <HTML><HEAD></HEAD><BODY><P>To do this you need to use a tool like NPrinting.  With this you can build a template in Excel and place data and images directly into your Excel template automatically.</P><P></P><P>There is more information on NPrinting on our website here:</P><P><A href="http://www.quickintelligence.co.uk/nprinting/" title="http://www.quickintelligence.co.uk/nprinting/">http://www.quickintelligence.co.uk/nprinting/</A></P><P></P><P>Steve</P></BODY></HTML> Sat, 22 Nov 2014 12:31:38 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481141#M1371 stevedark 2014-11-22T12:31:38Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481142#M1372 <HTML><HEAD></HEAD><BODY><P>Hi,  Great Macro... how do you get the 'screen grab' method to work ?</P><P></P><P>Tom</P></BODY></HTML> Fri, 05 Dec 2014 16:02:16 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481142#M1372 2014-12-05T16:02:16Z Re: QlikView App: Export Chart and Sheet to an Image File https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481143#M1373 <HTML><HEAD></HEAD><BODY><P>It's not a screen grab, as such, it is exporting the Sheet rather than a specific object.  This gives all objects laid out just as they are on the page.</P><P></P><P>Hope that helps.</P><P>Steve</P></BODY></HTML> Fri, 05 Dec 2014 16:14:12 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-Export-Chart-and-Sheet-to-an-Image-File/tac-p/1481143#M1373 stevedark 2014-12-05T16:14:12Z