Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
cmd command:
"C:\Program Files\QlikView\qv.exe" /r yourApplication.qvw
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.
You need to provide absolute path
Yes, I tried that and it's working!
Thank you.
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?
like in QMC. ADd reload only in QMC (I thought that you dont have QMC) . Please append this topic to ”solved”
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.
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