Export Image Sheet via VB Automation is truncated

[pablolabbe]

I'm using the following VBS code to export a sheet as an image, but Qlikview opens as a normal window, not maximized. Then, the resulting image is truncated (as attached).

How open Qlikview as full windows ?

set Qv = CreateObject("QlikTech.QlikView")
Set docObj = Qv.OpenDocEx ("C:\program files\QlikView\Exemplos\Documents\films.qvw",0,false) ' Open the document
wscript.echo docobj.name & " " &docobj.noofsheets
Set sheetObj = docObj.ActivateSheetById("SH10") ' Get the Sheet More Dimensions
Qv.WaitForIdle ' Wait for Sheet to finish painting
ret = sheetObj.("c:\Films_MoreDimensions.jpg", true)<div></div>

[pgalvezt]

Hi. I have a question:

If a want to export the sheet QV with that macro as JPG, Would I create a buttom for that? or How is the macro run automatically?

In my case I've created 5 sheets and I need to show it in a LED Screen each 30 sec. How can I do that?

Thanks.

[#3]

You have to:

1. Change the properties of the Qv.exe to open in a maximized mode. Yoou must

To fix it all you need to do is right-click on the application shortcut and select Properties. Under the Shortcut tab change the dropdown next to Run to Maximized.

2. You have to create a Batch File. This Batch File will be open Qlikview.exe in maximized mode and after open a qlikview document. (In our case we have to open the document reloaded and export a sheet as a jpg image and we put it as a task in the SO server administrator task).

The code we used in the batch file:

START "My script" /Max "C:\Program Files\QlikView\Qv.exe" /l "C:\Test.qvw"

Regards

Leandro Berman y Gustavo Pesce

[#4]

Hi,

I have two weeks with this issue, the biggest problem is when the task scheduler is executed, because the resolution to screen in backend or workspace when execute the task (execute .bat) have a small screen and i don´t have any idea to how changed default resolution screen.

Today your have the solution?

Thanks and Regards.

Alejandro Urrego