Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
raga
Contributor
Contributor

Auto Refresh data

Any one help me with this

How to auto update the data 

ex: when I am updating the data in excel the data need to be updated automatically from excel and I need to be reflected in dashboard without using reload data

#auto update data while inserting data in excel. 

Labels (1)
3 Replies
Parthiban
Creator
Creator

I think this is not possible. When u add the data in excel file need to be reload in Qliksense. 

vincent_ardiet_
Specialist
Specialist

One solution, which could sound dirty but I'm using it for some very specific cases, is basically to wait during the loading script that the data are moving.
I'm building a QVD file which stores the last modification date of the data source (could be an excel file or DB data).
Then we the app is reloaded, I'm comparing what is stored in the QVD and the data source, if they are identical, I'm pausing during a few and I'm checking again.
When the data source is newer, the script continues, loads the data, updates the application and finishes.
And this application is linked to a task which restart every x minutes (as once updated, the task needs to be restarted to watch the data source).

raga
Contributor
Contributor
Author

I already tried but it is not working if you come up with new solution it would be great for me and also if I get a related video, it would be so helpful because has I am new to QLIK.