Can anyone let me know whether is it possible to get the snapshot of reports in qlikview qvw? If so, can anyone share it please.
Actually my users will pull the reports from ms access databases every week thursday by the end of business and they wnats to have the same data from qlikview if they pull the report on coming tuesday. Is this possible with Qlikview?
How Bookmark option will work. with bookmark will they get the exact count of the values which they have in snapshot from msaccess on every thursday? If so, can you give one example please?
EDIT: I will upload msaccess database daily only once to Qlikview server. How can the Qlikview server connect to LIVE msaccess database whihc will be changing each second/minute.
I will upload msaccess database daily only once to Qlikview server. How can the Qlikview server connect to LIVE msaccess database whihc will be changing each second/minute.
That would depend on the Qlikview application. How long does it require to reload? If it reloads quick enough, you could schedule it to reload every minute, but should you?
The question should be, does it make sense to reload your Qlikview App every 5 minutes? What benefit does it provide? If the user needs real-time information, shouldn't they be accessing it from the respective production system?
But if they do insist on real-time reporting, you could check out the dynamic data update feature in Qlikview.
Qlikview always snapshots the data. If you like to report on Thursday, simply reload the Qlikview application on Thursday and don't reload it thereafter. When the user accesses that report, they will see it as on Thursday.
If you also require it to refresh regularly, simply maintain 2 Qlikview applications, one for the snapshot and another one refreshed with the latest data.
