topic Re: Date problem in Where clause in QlikView

Date problem in Where clause

hansdevr — Wed, 19 Apr 2017 13:31:18 GMT

While trying to work out incremental load on a QVD, I ran into the following problem:

First I created a QVD file with all records. Then I do a database read and store the result in a resident table. To concatenate new records into my QVD, I do a where clause on the resident table, finding records which have been added since last QVD creation time.

So, I read the creation time into a variable, like this (and this works fine):

Let vAanmaaktijd = num(QvdCreateTime('$(vQVDfolder)TopDesk\QVD TopDesk Versionated.qvd'));

The contence of $(vAaanmaaktijd) = 42844,561724537

After the database load I try to do the following:

Nieuwe_records:
Concatenate (Stamtabel) LOAD * Resident TopDesk_Wijzigingen
where num([Datum aanmaak]) > $(vAanmaaktijd);
Drop table Nieuwe_records;

When reloading I get the following error message:

What am I doing wrong? the field Datum aanmaak (creation date) is in format DD-MM-YYYY hh:mm:ss

Re: Date problem in Where clause

aarkay29 — Wed, 19 Apr 2017 13:46:14 GMT

Try with single quotes

where num([Datum aanmaak]) > '$(vAanmaaktijd)'

Re: Date problem in Where clause

sunny_talwar — Wed, 19 Apr 2017 13:46:27 GMT

May be use single quotes around your variable

Concatenate (Stamtabel)

LOAD *

Resident TopDesk_Wijzigingen
Where num([Datum aanmaak]) > '$(vAanmaaktijd)';

Re: Date problem in Where clause

hansdevr — Wed, 19 Apr 2017 13:59:36 GMT

You were of course BOTH right!!

Thnx guys!! You really helped me out!!