topic Macros and planification in QlikView

Macros and planification

souadouert — Mon, 26 Jan 2026 18:19:17 GMT

i need to know if i have the possiblity to automatically trigger (schedule) qlikview macros from server:

example the macro x will exécute one time per week with date variable

Re: Macros and planification

YoussefBelloum — Thu, 23 Nov 2017 09:19:35 GMT

Hi,

you can't schedule a part of your script from server, but you can do it on the script itself.

example:

beginning of the script..

IF CONDITION OK THEN

processing...

ENDIF

the rest of your script

make sure you have done the necessary (a lot of topics on the community tell you what to do exactly) so that your macros are not blocked by the server

Re: Macros and planification

marcus_sommer — Thu, 23 Nov 2017 12:25:01 GMT

A qmc-task won't execute any macros. But you could trigger external tasks with an EXECUTE statement. In your case this statement would open the qlikview desktop client which then runs your qv-application and with an OnOpen- or OnPostReload-trigger starts your macro. See here for an example: Re: Run Excel macro via QMC.

- Marcus

Re: Macros and planification

souadouert — Thu, 23 Nov 2017 14:14:46 GMT

i mean qlikview macro Marcus

Re: Macros and planification

marcus_sommer — Thu, 23 Nov 2017 14:33:21 GMT

It's the same. Here further examples:

Execute Command for QV.EXE without saving.

Re: Reloading more qvw files in Qlik Sense using EXECUTE command

Further it could be useful to to trigger the qvw directly else with a further batch or a windows-task.

- Marcus

Re: Macros and planification

YoussefBelloum — Thu, 23 Nov 2017 14:53:10 GMT

Hi Marcus,

so it's just impossible to run macros on the server ?

Re: Macros and planification

marcus_sommer — Thu, 23 Nov 2017 15:06:52 GMT

Yes, within qmc-tasks executed by the qvb.exe it's impossible. I'm not really sure about the reasons - it could be security restrictions or what I think is more likely that the qvb.exe only contained purely the load-engine and no GUI or API ...

- Marcus

Re: Macros and planification

YoussefBelloum — Thu, 23 Nov 2017 15:15:36 GMT

because on the QMC the is an option to allow macros..

it is a bit confusing

Re: Macros and planification

marcus_sommer — Thu, 23 Nov 2017 15:28:29 GMT

This meant the server (qvs.exe) and not the publisher-part (qvb.exe) and only if you accessed the server per desktop client or IE plugin.

- Marcus

Re: Macros and planification

YoussefBelloum — Thu, 23 Nov 2017 15:43:49 GMT

I'm not sure I can follow here..

no matter if we have publisher or not, on the QMC:

if i have an app running on the server (publisher on not), with that option enabled, on that app we have a Macro, the macro will run or not ?

Re: Macros and planification

marcus_sommer — Thu, 23 Nov 2017 16:12:42 GMT

Macros won't run during the reload per qmc-task. Accessing the application on the server per desktop client or IE plugin macros could run if they are enabled here and within the document- and user-properties.

- Marcus

Re: Macros and planification

YoussefBelloum — Thu, 23 Nov 2017 16:18:12 GMT

ok, thank you