Hourly full reload & intra-hour append

[Anonymous]

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.

[Frank_Hartmann]

Have a look at the attached qvw

hope it helps

This could also be interesting:

Batch file script to reload Qlikview Applications

[marcus_malinow]

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