Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Demlet
Contributor III
Contributor III

How to load newest data, without reloading all the data?

I am pulling data from an an API that doesn't have pagination. My workaround to this was to load all the old data into QlikSense via a file, then have the rest connector update each month/day with the latest data.

Old data spans from 5/1/2016 to 5/1/2018. Loaded via AttachedFile.

New data will be for each month after this via REST Connector, so 5/2018-6/2018, then each month following.

The problem I am realizing is that when the new data reloads each month via REST API GET, it will wipe out / replace, the previous months data

How do I keep the data saved after each re-load, and add to it's results rather than refreshing it?

Thanks in advance

1 Reply
petter
Partner - Champion III
Partner - Champion III

You can make use of QVD-files for the purpose of keeping a complete history and adding to it on a regular basis.