topic Update qvd, need help in QlikView

Update qvd, need help

Tue, 20 Dec 2011 08:44:29 GMT

Hi all.

I want to update my qvd and make an incremental load with my database. So, my table is :

Id (primary key) integer

Status varchar

Name varchar

Date date MM/DD/YYYY

For this, my script is :

Let ThisExecTime = ReloadTime();

QLIKVIEW_TEST:
SQL SELECT *
FROM DB.QLIKVIEW_TEST
WHERE (Date>= convert(DateTime,'$(ThisExecTime)',103));

Concatenate LOAD Id, Statut, Name, Date
FROM QLIKVIEW_TEST.qvd (qvd)
WHERE NOT EXISTS (Id);

store QLIKVIEW_TEST into QLIKVIEW_TEST.qvd(qvd);
Drop table QLIKVIEW_TEST;

But I can't update my table.

Please, i need you.

Regards,

Update qvd, need help

Sokkorn — Tue, 20 Dec 2011 11:18:36 GMT

Hi,

Please check in my attached file in http://community.qlik.com/message/173636#173636

Regards,

Sokkorn Cheav

Re: Update qvd, need help

rwunderlich — Tue, 20 Dec 2011 14:28:12 GMT

You might want to check out using Qlikview Components (Qvc) http://QlikviewComponents.org for incremental loads. Here's how your code would look using Qvc.

$(Include=path-to-qvc\qvc_runtime\qvc.qvs)

CALL Qvc.IncrementalSetup ('QLIKVIEW_TEST', 'Date', 'Id');

[$(Qvc.Loader.v.Tablename)]:

SQL SELECT *

FROM DB.QLIKVIEW_TEST

WHERE $(Qvc.Loader.v.IncrementalExpression)

;

CALL Qvc.IncrementalStore;

-Rob

http://robwunderlich.com