topic Re: Incremental load in QlikView

Incremental load

Thu, 19 Feb 2015 04:12:24 GMT

I want to apply incremental load to an existing QVD file.

The data to be downloaded is from my ERP Navision.

When i use the following expression in Excel, it works fine.

LET vIncrementalExpression = 'WHERE ModDate >=' & peek('maxdate');

But when i try to use this as part of SQL select statement, i get syntax error.

Can anyone help me please.

Thu, 19 Feb 2015 09:04:15 GMT

Hi Kartik.

Can u check the datetime format required by SQL. After getting maxdate using peek, it will be required to format in same way as required in SQL.

Thu, 19 Feb 2015 09:10:57 GMT

Ashish,

Actually i tried entry number (unique number) also.

Even that is not working.