Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

apoorvasd
Contributor 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
New Contributor III

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

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
New Contributor III

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

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

apoorvasd
Contributor II

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

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
Honored Contributor II

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

You need to provide absolute path

apoorvasd
Contributor II

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

Yes, I tried that and it's working!

Thank you.

apoorvasd
Contributor II

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

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
New Contributor III

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

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

apoorvasd
Contributor II

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

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
New Contributor III

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

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

Community Browser