I'm very new to Qlikview and this community, so please point in the direction of the thread of this has already been asked and answered. I haven't been able to find anything related to this question.
I've imported data from an Access database in to Qlikview. Is there a way to update Qlikview when the data in Access gets updated? I haven't been able to find an "easy-to-understand" answer to this question. Is it because Qlikview is meant to be more of a snapshot of data that already exists and will no longer be updated? Any help is appreciated! Thanks.
QlikView application gets data on reload. That is a snapshot at the reload time. If you want fresh data, you have to reload it again. Changes in the data source between the reloads are not reflected in the application.
Qlikview cannot know when the access database is updated. A (re)load will load the data that exists at that moment in the source database. If you need to refresh the data in the qlikview document you can manually reload the qlikview document or create a scheduled task to reload the document periodically. Or perhaps create a macro in the Access database to reload the qlikview document.
