Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
nicklisterman
Contributor II

Hourly full reload & intra-hour append

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.

2 Replies
Frank_Hartmann
Honored Contributor

Re: Hourly full reload & intra-hour append

Have a look at the attached qvw

hope it helps

This could also be interesting:

Batch file script to reload Qlikview Applications

marcus_malinow
Valued Contributor III

Re: Hourly full reload & intra-hour append

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