incremental load custom where clause about qlikview-components HOT 2 OPEN

Hi,
Interesting idea! Having taken a look I can't see any obvious work around but Rob knows the incremental routines better than myself so he might be able to suggest one. We could possibly use the existing Qvc.Loader.v.BaseValue variable to implement this which is normally only used when performing the first reload or when a full reload has been requested.

Regards
Matt

from qlikview-components.

Hi Matt, to cut off the "n" days in QVD, just create temporary table that had all date values with in "n" range and Inner join with your QVD table. The down side is we need to add new field "date" if we don't have a date field (timestamp field).

from qlikview-components.