Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
i mean qlikview macro Marcus
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
Hi Marcus,
so it's just impossible to run macros on the server ?
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
because on the QMC the is an option to allow macros..
it is a bit confusing
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
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 ?