topic Re: Reloading Data in QlikView

Reloading Data

Thu, 16 Apr 2015 16:43:16 GMT

Good Afternoon,

I need some help with Reloading data for my daily reports.

I have a QlikView Document that contains tables with data from 2009 thru 2015. I need Reload only Current year (2015 tables). Is there a way that I can select only the tables that I want to reload? The Script is taking almost 2 hours to run because if is reloading all tables (2009 - 2015 tables).

Thank you for your input.

Claudia

Re: Reloading Data

Thu, 16 Apr 2015 16:57:56 GMT

Can you use the Year in the where clause while you Load.

Re: Reloading Data

MK_QSL — Thu, 16 Apr 2015 17:03:08 GMT

You can still load all data if necessary for your application point of view.. search Incremental Load and implement the same in your application.

But in case no need of all data, you can obviously use as what ramko496 said,, restrict the load as below

Load * From TableName where Year = Year(Today());

Re: Reloading Data

maxgro — Thu, 16 Apr 2015 17:08:43 GMT

split and save (in qvd) your data by year

load onlyurrent year from db and other years from qvd

for incremental load you can read this post (look at Anand answer and atachments) or search in Qlik help (Using QVD file for incremental load)

Incremental Load