Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Schedule image creation

In QlikView I have created a new blank file.

Then I create a new Sheet Object, Text Object. In the text object i type (General, Foreground, Text) =now()

Now I want to create a Macro that export this object to an image on disk.

I then want this macro to be executed on a scheduled basis.

Can anyone help me on what to click and type to do this?

9 Replies
Not applicable

Schedule image creation

I have managed to create a Macro (Ctrl + M)

sub createImage
ActiveDocument.GetSheetObject("TX01").ExportBitmapToFile "C:\temp\staticimage.bmp"
end sub

When I click Check it seems to work and Test creates the image.

My next step is to create a trigger from menu Settings, Document properties, Triggers. I have tested most of the available Events but it doesnt work when scheduled. I can select OnOpen, Add Action, Add, External Run Macro, createImage, Save the file and reload it and the image creation works.

I want it scheduled so in Enterprise Management Console, Documents I select the file and tab Reload. Enable the Reload Schedule and I can see in Status tab it is running but no image is created.

Not applicable

Schedule image creation

when i fetch image from macro on post relode it not give me full image

Kindly help me it urgent basic

Regards

Ashish

Not applicable

Schedule image creation

My half image

Not applicable

Schedule image creation

hi,

the image that you have shown seems to be some sort of pdf report! if that's the case then you should be copying your image( dashboard ) and then goto reports add and then edit and finally paste your screen onto it. Now the second step is to create a macro for automatic sending it to the required customers etc. now for this purpose press ctrl+m and goto edit module section and you have type the coding...the language you should be using is vb though you have the option of using java script but is is not quite recommended by qlikview so better use visual basic.

now you have to ask the client their smtp server port and other networking requirements based on which you can test your sending option.

if you need help on the coding part of vb then kindly let me know.

Now after when the above macros are created you have to schedule your qlikview application on daily basis for auto generation of your reports( or image in your case ). for this purpose you need to create batch file and for reloading your have to give \r in between your qlikview exe file and the application.

Gaurav

Not applicable

Schedule image creation

kindly provide me macro fetch the full image of sheet than schedule it macro on post relode

I am waiting for your repliy

Regards

Ashish

Not applicable

Schedule image creation

hi Gaurav khare

I waiting for your reply

Regards

Ashish


Not applicable

Schedule image creation

According to instructions from support I have modified the macro:

sub createImage
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.GetSheetObject("TX01").ExportBitmapToFile "C:\temp\staticimage.bmp"
end sub

and in Server Management Console, activated "Allow Execution of Unsafe Macro".

I have also changed the permissions on C:\temp to allow all users full control, but still no image is created.

Not applicable

Schedule image creation

I have use this macro again my image is cropping please help me

how can export sheet in image format????????

Regards

Ashish

bradshields
Contributor

Schedule image creation

Hi Asish

I have the same issue. I think it is because QlikView doesn't open full screen. It seems the image created is cut in size and represent only the amount of the dashboard that is visible when qlikview opens. I cannot see any way of opening qv fullscreen using the api. Anyone else have an idea how to do this?

Community Browser