Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change date in delta load Qlikview

Hello

How can i change the date in DL_Max?

See attached.

7 Replies
maxgro
MVP
MVP

SET DateFormat='DD.MM.YYYY';

s:

LOAD DL_Max FROM DL_EVTIMEFORBRUKHIST.qvd  (qvd);

let v=Peek('DL_Max');

s2:

NoConcatenate load date(num('$(v)')+1) as DL_Max AutoGenerate 1;

STORE s2 into DL_EVTIMEFORBRUKHIST.qvd (qvd);

Anonymous
Not applicable
Author

i need the date to be 30.11.2014

maxgro
MVP
MVP

s2:

load

date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;

STORE s2 into DL_EVTIMEFORBRUKHIST.qvd (qvd);

Anonymous
Not applicable
Author

Script:

LOAD DL_Max

FROM

(qvd);

let v=Peek('DL_Max');

s2:

load

date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;

STORE DL_EVTIMEFORBRUKHIST into DL_EVTIMEFORBRUKHIST.qvd (qvd);

_____________________

New problem:

Now todays date appears AND 30.11.2014.. any suggestions?

Thanks for the help so far.

sebastianlettner
Partner - Creator
Partner - Creator

Hi

try adding NoConcatenate.

LOAD DL_Max

FROM

(qvd);

let v=Peek('DL_Max');

DL_EVTIMEFORBRUKHIST:

NoConcatenate

load

date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;

STORE DL_EVTIMEFORBRUKHIST into DL_EVTIMEFORBRUKHIST.qvd (qvd);

Anonymous
Not applicable
Author

when i add NoConcatenate the date 30.11.2015 disappears.

gandalfgray
Specialist II
Specialist II

I am not sure why you do the first load, anyway give that table a name (other than DL_EVTIMEFORBRUKHIST):

a_named_table:

LOAD DL_Max

FROM

(qvd);

let v=Peek('DL_Max');

DL_EVTIMEFORBRUKHIST:

NoConcatenate

load

date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;

STORE DL_EVTIMEFORBRUKHIST into DL_EVTIMEFORBRUKHIST.qvd (qvd);