topic Re: How to run the macros automatically ? in QlikView

How to run the macros automatically ?

Anonymous — Wed, 21 Jan 2015 12:59:37 GMT

Hi to all Community peoples,

I have a doubt regarding qlikview macros .

I'm created a macro code to export the data to excel and stored the excel file in my machine,

I'm doing this manually by every day,

I want to run the MACRO(Macro Name is Export_To_Excel) automatically in every day for particular time is it possible ??

Thanks in advance.....

Re: How to run the macros automatically ?

alexandros17 — Wed, 21 Jan 2015 13:01:48 GMT

Yes it is, you have to use a postreload event (trigger) but ... unfortunately this trigger and macros do not work togheter so you need a batch (scheduled by window) that launch the document

Re: How to run the macros automatically ?

ashfaq_haseeb — Wed, 21 Jan 2015 13:04:12 GMT

Hi,

You can try with windows scheduler.

Regards

ASHFAQ

Re: How to run the macros automatically ?

Anonymous — Wed, 21 Jan 2015 13:04:19 GMT

Hi Alessandro,

Thanks for u r quick reply ..

I didn't understand the solution what u said..

Can u please share if possible a sample document or sample application ???

Thanks in advance...

Re: How to run the macros automatically ?

Anonymous — Wed, 21 Jan 2015 13:08:01 GMT

Hi Ashfaq,

I known as from windows scheduler we can reload the entire qlikview application, I think so we are not able to run the particular MACRO in the qlikview application, If possible with windows scheduler please give me in detail..

Thanks in Advance....

Re: How to run the macros automatically ?

alexandros17 — Wed, 21 Jan 2015 13:10:22 GMT

Unfortunately I have not a sample document, here there are the step to create one:

1) in the document menu: Settings -> Document Properties -> Trigger -> onPostReload -> Add -> external -> Run Macro write the name of your macro (the one that export data)

2) in the task scheduler (in windows) you have to define a new task that runs a batch file like the following one:

"C:\Program Files\QlikView\Qv.exe" /r "E:\QlikSource\Sales\MyDocumentName.qvw" >> E:\myDirectory\MyDocumentName.log

Re: How to run the macros automatically ?

Anonymous — Wed, 21 Jan 2015 13:28:39 GMT

Hi Alessandro,

Thanks for u quick reply....

This is very helpful and resolved my doubt also .....

Thanks a lot ........