topic Re: Trouble with Macros in QlikView

Trouble with Macros

Tue, 18 Feb 2014 15:37:00 GMT

I'm trying to create a macro to export a chart as a JPG file.

From within the Edit Script (Ctrl-E) I have added a new tab and entered the following

FUNCTION ExportObjectToJpg( ObjID, fName)

ActiveDocument.GetSheetObject(ObjID).ExportBitmapToFile fName

END FUNCTION

SUB CallExample

ExportObjectToJpg "CH01", "C:\CH01Image.jpg"

END SUB

The following error is displayed

Unknown statement

FUNCTION ExportObjectToJpg( ObjID, fName)

ActiveDocument.GetSheetObject(ObjID).ExportBitmapToFile fName

END FUNCTION

SUB CallExample

ExportObjectToJpg "CH01", "C:\CH01Image.jpg"

END SUB

I obtained the script from here:

QlikView Macros – Useful collection | Lucian Cotea

and also tried

FUNCTION RunExe(cmd)

CreateObject("WScript.Shell").Exec(cmd)

END FUNCTION

SUB CallExample

RunExe("c:\Program Files\Internet Explorer\iexplore.exe")

END SUB

which again fails.

I'm at a loss, any help greatly appreciated.

Re: Trouble with Macros

Gysbert_Wassenaar — Tue, 18 Feb 2014 20:25:39 GMT

That code from Lucian works fine for me. Do you actually have a chart object with Id CH01?

Re: Trouble with Macros

Tue, 18 Feb 2014 20:42:18 GMT

I Do, but as mentioned even the launch IE script won't work either.

i Must be missing something obvious.

Re: Trouble with Macros

fkeuroglian — Wed, 19 Feb 2014 02:06:14 GMT

Hi, it works fine for me

do you have this root path?

do you have permission to write in c:?

do you have select in combo box in macro ALLOW SYSTEM ACCES?

something in your configuration is the problem

good luck!

Fernando

Re: Trouble with Macros

Wed, 19 Feb 2014 08:06:30 GMT

Where do I find

"select in combo box in macro ALLOW SYSTEM ACCESS?"

thanks

Re: Trouble with Macros

jerrysvensson — Wed, 19 Feb 2014 08:14:07 GMT

just to make sure. You wrote Ctrl-E, that opens the script editor.

This code should go in macro editor Ctrl-M.

Re: Trouble with Macros

Wed, 19 Feb 2014 08:21:05 GMT

Hi Jerry, you found the problem.

The macro now works, as you pointed out I had it in the script editor as I pointed in in my first post.

How do I call the macro to run when refreshing?

thanks

Re: Trouble with Macros

jerrysvensson — Wed, 19 Feb 2014 09:33:45 GMT

You can trigger your macro on PostReload.

But you have to do a batch reload using qv.exe /r app.qvw, since triggers will not trigger if you run a standard Publisher task.

Re: Trouble with Macros

Wed, 19 Feb 2014 11:24:03 GMT

Ok, created a DOS batch file which runs and updates the data, but does not create the jpg files.

Do I need a trigger in the file?

Re: Re: Trouble with Macros

fkeuroglian — Wed, 19 Feb 2014 11:27:54 GMT

Hi, try this document and tell me how was

Re: Trouble with Macros

jerrysvensson — Wed, 19 Feb 2014 11:48:47 GMT

Yes you need to add a trigger to the event OnPostReload

Re: Trouble with Macros

Wed, 19 Feb 2014 12:27:09 GMT

Hi Fernando, Think you posted just after me. Macro now working, but need it to run automatically after an update.

I need to use the "on postreload" option I believe, so just need to work out how.

thanks

steve

Re: Trouble with Macros

jerrysvensson — Wed, 19 Feb 2014 12:29:17 GMT

Add an Action.

Action Type . External

Action : Run macro.

Re: Trouble with Macros

Wed, 19 Feb 2014 17:32:01 GMT

Got it working finally. Wasn't sure what macro name to use. Second name worked so all is good.

Thank you all for your help.