topic Re: getting new data when reloading in QlikView

getting new data when reloading

rathnam_qv — Thu, 05 Sep 2013 09:41:42 GMT

hi all,

is there any way to get newly added data with old data from qvd when we are using button with reload actions...can any one help me urgent

michael_maeuser — Thu, 05 Sep 2013 09:47:27 GMT

you can do an incremental load. s.th. like that

TestTable:

LOAD

Key,

FROM

\QVD\Test.qvd

(qvd);

UNQUALIFY *;

//Get latest value from QVD

TEMP:

LOAD Max(Key) as MaxKey

RESIDENT TestTable;

LET vExample=peek('Max%Key',-1,'KeyTEMP');

drop Table TEMP;

//Add new values

Concatenate (TestTable)

Entries:

LOAD

Key,

SQL SELECT *

FROM "$(Database)".dbo."$(Company)$Entries"

WITH (NOLOCK)

WHERE "Key" > $(vExample)

;

techvarun — Thu, 05 Sep 2013 09:53:57 GMT

Pls Do Incremental LOAD

Regards