topic Re: Auto Refresh data in Featured Members

Auto Refresh data

raga — Mon, 27 Nov 2023 07:55:00 GMT

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.

Re: Auto Refresh data

Parthiban — Mon, 27 Nov 2023 08:05:28 GMT

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

Re: Auto Refresh data

vincent_ardiet_ — Mon, 27 Nov 2023 10:31:53 GMT

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).

Re: Auto Refresh data

raga — Wed, 29 Nov 2023 06:50:33 GMT

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.