Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suresh_cholleti
Contributor
Contributor

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
suresh_cholleti
Contributor
Contributor
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

suresh_cholleti
Contributor
Contributor
Author

I'm getting this error using Reload button.

"Error: Reload failed. isPartial:false"


Can anyone help on this?