Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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. How do I keep the data saved after each re-load, and add to it's results rather than refreshing it?

1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

Hi Derek,

Firstly save the data for every reload into a QVD.

For every refresh concantenate the new data to the QVD.

Coming to the process of fetching only new data, please have a look at the following

Incremental Load

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Incremental Load in Qlikview - Sources

Regards

Vamsee

View solution in original post

3 Replies
vamsee
Specialist
Specialist

Hi Derek,

Firstly save the data for every reload into a QVD.

For every refresh concantenate the new data to the QVD.

Coming to the process of fetching only new data, please have a look at the following

Incremental Load

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Incremental Load in Qlikview - Sources

Regards

Vamsee

Demlet
Contributor III
Contributor III
Author

Hi Vamsee,

Thank you for the quick reply! Both links are very helpful, but explicitly have QlikView in the title. Can you confirm the Incremental Load / QVD solutions will work in QlikSense Enterprise? Thanks.


-Derek

vkish16161
Creator III
Creator III

Derek.

Incremental loads will work in QlikSense / QlikCloud. Irrespective of the platform.