topic Re: Hourly full reload & intra-hour append in QlikView

Hourly full reload & intra-hour append

Anonymous — Tue, 21 Jun 2016 14:44:44 GMT

Is it possible to perform a conditional load? I have a dashboard with hourly reloads and I'm interested to know if it is possible to run a reload every ~5 minutes within the hour to append new records and full reload on the hour.

Re: Hourly full reload & intra-hour append

Frank_Hartmann — Tue, 21 Jun 2016 14:56:09 GMT

Have a look at the attached qvw

hope it helps

This could also be interesting:

Batch file script to reload Qlikview Applications

Re: Hourly full reload & intra-hour append

marcus_malinow — Tue, 21 Jun 2016 14:58:09 GMT

Nick,

yes it's possible - you're looking here to do a partial reload. I'm not sure whether it is possible to schedule like this without using QlikView Publisher.

Anyway, when you do a partial reload, you can specify each of your loads as an ADD or REPLACE, which will allow for concatenation, or replacement of your tables respectively. If one of your tables exists from your full load and doesn't have an ADD or REPLACE associated with it, it will remain in your data model from your initial full load.

Also there's an IsPartialReload() function which will allow you to add some control structures to your reload acript.

Marcus