Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

demlet123
New 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
MVP
MVP

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

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