topic Re: How to set up a trigger to click a button automatically every one hour? in QlikView

How to set up a trigger to click a button automatically every one hour?

apoorvasd — Fri, 15 Dec 2017 09:52:08 GMT

Hello Everyone,

I require a quick help on this question.

I have a button created in QlikView app. When clicked on it, data in my straight table object is exported to excel and placed in a specific location. Instead of manually clicking on this button, is there a way to set up a trigger for this button so that the excel file is replaced in the location automatically every one hour?

Any help on this?

Thank you.

Re: How to set up a trigger to click a button automatically every one hour?

mariusz_kumansk — Fri, 15 Dec 2017 10:14:30 GMT

1. Find your macro (Ctrl + M)

2. Run macro after reload (Document Properties >> Trrigers >> OnPostReload)

3. Add a new task in "task scheduler" (System Windows) that will be reloaded your QV application every hour.

Re: How to set up a trigger to click a button automatically every one hour?

mariusz_kumansk — Fri, 15 Dec 2017 10:17:54 GMT

cmd command:
"C:\Program Files\QlikView\qv.exe" /r yourApplication.qvw

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 05:34:20 GMT

Hi,

Should I provide full path where my application is stored or is it sufficient if I provide the name of the application in the below command line?

"C:\Program Files\QlikView\qv.exe" /r yourApplication.qvw

Thank you.

Re: How to set up a trigger to click a button automatically every one hour?

sushil353 — Wed, 20 Dec 2017 05:38:05 GMT

You need to provide absolute path

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 05:41:49 GMT

Yes, I tried that and it's working!

Thank you.

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 05:46:35 GMT

Just a quick question.

If I create a supporting task for this batch file in QMC, does it reload the qvw in server locally or will it reload the qvw in QMC like other tasks in QMC do?

Re: How to set up a trigger to click a button automatically every one hour?

mariusz_kumansk — Wed, 20 Dec 2017 06:02:56 GMT

‌like in QMC. ADd reload only in QMC (I thought that you dont have QMC) . Please append this topic to ”solved”

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 06:16:14 GMT

Excel sheet is getting updated in the location specified in the macro only when I reload the batch file locally in the server, but when the supporting task in QMC completes the reload of batch file, the excel file isn't updated.

Any idea where could be the issue?

Thank you.

Re: How to set up a trigger to click a button automatically every one hour?

mariusz_kumansk — Wed, 20 Dec 2017 06:23:42 GMT

Don’t use bat File.

1. Add your File in QMC task (qvw file)

2. Ctrl+ M allow macro unlimited access in your server and save file

Should works, Please double check

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 06:30:02 GMT

Hi,

Where do I provide unlimited access to my macro in the server? I have only below options

Re: How to set up a trigger to click a button automatically every one hour?

mariusz_kumansk — Wed, 20 Dec 2017 06:31:33 GMT

SET

‌1. Allow system access

2.system access

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 06:37:42 GMT

Hmm...no it still isn't working in QMC for me! Works when reloaded locally. Is there any security option that I have to check in either "Document Properties" or "User Preferences"?

Thank you.

Re: How to set up a trigger to click a button automatically every one hour?

tamilarasu — Wed, 20 Dec 2017 07:19:10 GMT

Hi Apoorva,

1) Settings -> Document properties ->OnPostReload -> Add Edit Actions-> Run Macro -> Enter macro name as "Export" -> Ok -> Apply -> Ok

2) Macro code:

Sub Export

rem ** press button BU01 **

ActiveDocument.GetSheetObject("BU01").Press

'Msgbox "Button 1 Clicked"

End Sub

Make sure you enter the correct object id for the button. Good luck.

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 08:48:27 GMT

Hello,

Thanks for the response!

Could you please explain how this works?

Thank you.

Re: How to set up a trigger to click a button automatically every one hour?

tamilarasu — Wed, 20 Dec 2017 08:52:36 GMT

Hi,

It's simple. As you can see we are triggering the macro once we reload the application. The macro is activating the button using the syntax ActiveDocument.GetSheetObject("BU01").Press. Let me know whether this is working for you or not.

Re: How to set up a trigger to click a button automatically every one hour?

apoorvasd — Wed, 20 Dec 2017 09:01:02 GMT

Hmm...understand! But even this is not working when I reload the app in QMC! Works in the server. Any idea why isn't this working?

Re: How to set up a trigger to click a button automatically every one hour?

tamilarasu — Wed, 20 Dec 2017 09:13:15 GMT

Yes. It's not working for me too in QMC. Please check the below threads.

Qlikview export macro is not working from QMC | Qlik Community

https://community.qlikview.com/thread/156613#735375

Re: How to set up a trigger to click a button automatically every one hour?

mariusz_kumansk — Wed, 20 Dec 2017 09:32:47 GMT

Could you send this application??