Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop

Hi Team,

I want to run existing script in "Data load Editor" at regular Intervals (Assume every 1 hour) & update KPI statistics "App Overview" with already existing measures.

Is it possible to do? Please share sample script to perform this requirement.

I have remote desktop open 24X7 & data will be pumped in to folder "C:\Users\sXXXX\Documents\Qlik\Data" every one hour & accordingly all KPI stats should be updated in Qlik Sense Desktop accordingly as per new data.

It will be more helpful if i get the reply at the earliest.

Thanks

Suresh

+91 9871200685

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try something like a AutoIT or AutoHotKey script and schedule it with windows tasks.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

Try something like a AutoIT or AutoHotKey script and schedule it with windows tasks.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi Gysbert,

Thanks for revert, I have explored AutoHotKey script & found its quite interesting.

I used below script to operate, Coordinates (2069,42) received from windows spy tool (snapshot) enclosed but the problem is with accuracy, Capture.PNG@

Coordinates which I'm using from Windows Spy are not accurate due to which after running script.. execution is happening some where across the screen.

I tried all possibilities to resolve but couldn't helpful

Is there any way you can help me out from this.

;      Main Script

;---------------------------

;---------------------------

Pause Off


Sleep, 2000

Mousemove, 2069, 42

Sleep, 1000

click, 2069 45

Sleep 1000


ExitApp

^z::Pause

^x::ExitApp


brunobertels
Master
Master

Anonymous
Not applicable
Author

I'm getting this error using Reload button.

"Error: Reload failed. isPartial:false"


Can anyone help on this?