topic Macro does not work with /r option? in QlikView

Macro does not work with /r option?

Mon, 17 Oct 2011 07:14:37 GMT

I'm tryng to develop a macro to create a report file and then send it with email.

I set the macro to be executed after data reload; if I run manually the reaload it works....

But when I create a scheduled job with /r option the macro seems to stop after creating the file, before sending email and process qv.exe hangs on... any idea?

Macro does not work with /r option?

SunilChauhan — Mon, 17 Oct 2011 07:52:11 GMT

Create one batch file and edit then write like below

"exe path " /r "Application path"

example:

"C:\Program Files\QlikView\qv.exe" /r "C:\Documents and Settings\skchauhan\Desktop\test.qvw"

settings-> document properties-> trigger-> on post reload -> write the macro name.

hope this help

Macro does not work with /r option?

pkkushwaha — Thu, 03 Nov 2011 19:18:40 GMT

Hi,

I am also facing same issue with server 2008.

If i run bat file manually it is reloading the file and exporting the table and chart into excel and ppt ;but once i am trying to run it via schedular it got stop after reload.

Can any one help with some ideas.

thanks in advance

Macro does not work with /r option?

Thu, 03 Nov 2011 19:23:01 GMT

We use:

psexec -u us\username -p userpassword "c:\Program Files (x86)\QlikView\qv.exe" -r "Path\FileName.qvw"

hth,

Stephen

Macro does not work with /r option?

pkkushwaha — Sat, 05 Nov 2011 09:33:33 GMT

Hi Stephen,

i am getting below error

'psexec' is not recognized as an internal or external command,

operable program or batch file.

psexec -u use\machinename -p machinepwd "c:\Program Files (x86)\QlikView\qv.exe" -r "F:\Automated Report\DB.qvw"

could you please brief the use of prexec or provide some sample bat or provide any url through which i can configure it.

Thanks,

pradeep

Macro does not work with /r option?

Mon, 07 Nov 2011 15:25:55 GMT

Search Goolge for psexe. It is a free Microsoft program that you need to download and install.

Stephen