Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental load for a qvw

We want to keep our sales history for 3 years available to the users in a qvw file from our Transform and each day just add the current day's sales data. This is necessary to minimize the run time. I figured out a way to do this in the extract to update the qvd, but I cannot figure out how to do this in the Transform to minimize the time to re-create the qvw with the additional data.

For example purposes we have a source file for the current days sales, a SalesHistory qvd , a DailySalesqvd, and a Sales qvw.

Can someone please help me with this?



Community Browser