topic Re: LOAD QVD where clause + qlik variables in QlikView

LOAD QVD where clause + qlik variables

Wed, 25 Nov 2020 16:16:04 GMT

Hey guys

I'm implementing incremental load, but i'm having problems with the load where clause when i use variables

LET start_date = '2015-01-05';

LET end_date = '2015-01-07';

LOAD

field1,

field2,

date,

field3,

...

FROM

[qvdpath\qvdfile.qvd] (qvd)

WHERE

(date < $(start_date)

and date > $(end_date));

And it loads if i Load like:

LOAD

field1,

field2,

date,

field3,

...

FROM

[qvdpath\qvdfile.qvd] (qvd)

WHERE

(date < '2015-01-05'

and date > '2015-01-07');

I'm using that to load the QVD without some dates, so i can concatenate updated versions (reload dates from qvd)

Ty!

Re: LOAD QVD where clause + qlik variables

jmvilaplanap — Thu, 14 Sep 2017 14:47:50 GMT

Hi,

Maybe is because QV is evaluating the date and writing it as a number. Try with SET.

let and set difference

Regards

Re: LOAD QVD where clause + qlik variables

effinty2112 — Thu, 14 Sep 2017 14:49:03 GMT

Hi Victor,

Try

WHERE

(date < '$(start_date)'

and date > '$(end_date)');

Cheers

Andrew

Re: LOAD QVD where clause + qlik variables

Thu, 14 Sep 2017 14:49:57 GMT

Hey Jose

Changed to SET, but it still ignore it and loads full qvd

Re: LOAD QVD where clause + qlik variables

Thu, 14 Sep 2017 14:50:30 GMT

Hell yeah man!

Ty!

Re: LOAD QVD where clause + qlik variables

Colin-Albert — Thu, 14 Sep 2017 14:50:41 GMT

Use makedate as this will generate a correct numeric date value

LET start_date = makedate(2015, 1, 5) ;

LET end_date = makedate(2015, 1, 7);