Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

Macros and planification

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



Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

11 Replies
YoussefBelloum
Champion
Champion

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

marcus_sommer

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

souadouert
Specialist
Specialist
Author

i mean qlikview macro Marcus

marcus_sommer

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

YoussefBelloum
Champion
Champion

Hi Marcus,

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

marcus_sommer

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

YoussefBelloum
Champion
Champion

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

it is a bit confusing

marcus_sommer

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

YoussefBelloum
Champion
Champion

I'm not sure I can follow here..

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

image030.jpg

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 ?