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: 
apoorvasd
Creator II
Creator II

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

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.

18 Replies
mariusz_kumansk
Contributor III
Contributor III

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.

mariusz_kumansk
Contributor III
Contributor III

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

apoorvasd
Creator II
Creator II
Author

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.

sushil353
Master II
Master II

You need to provide absolute path

apoorvasd
Creator II
Creator II
Author

Yes, I tried that and it's working!

Thank you.

apoorvasd
Creator II
Creator II
Author

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?

mariusz_kumansk
Contributor III
Contributor III

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

apoorvasd
Creator II
Creator II
Author

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.

mariusz_kumansk
Contributor III
Contributor III

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