topic Previous function in QlikView

Previous function

krishna20 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

I am having date and I need New date fields's data should be like below. How can I achieve this at script level as a new field using peek or previous functions.

Date	New Date
01-09-2018	02-09-2018
02-09-2018	03-09-2018
03-09-2018	04-09-2018
04-09-2019	05-09-2018
05-09-2018	06-09-2018
06-09-2018	07-09-2018
07-09-2018	-

Regards

krishna

Re: Previous function

shiveshsingh — Sun, 23 Sep 2018 09:27:29 GMT

Try this

load Date#(Date,'DD-MM-YYYY') as Date;

load * inline

[Date

01-09-2018,

02-09-2018,

03-09-2018,

04-09-2018,

05-09-2018,

06-09-2018,

07-09-2018];

load Date, Previous(Date) as New_Date

Resident T

order by Date desc;

Re: Previous function

krishna20 — Mon, 24 Sep 2018 05:21:44 GMT

Hi Shivesh,

Thanks for your inputs, but not getting exact result.

Re: Previous function

jyothish8807 — Mon, 24 Sep 2018 06:13:36 GMT

Hi Kalyan,

Try this:

load Date#(Date,'DD-MM-YYYY') as Date ;

load * inline

[Date

01-09-2018,

02-09-2018,

03-09-2018,

04-09-2018,

05-09-2018,

06-09-2018,

07-09-2018];

NoConcatenate

Load

Date,

previous(Date) as NewDate

resident A

order by Date desc;

drop table A;

Br,

Re: Previous function

shiveshsingh — Mon, 24 Sep 2018 07:43:14 GMT

Sorry, i missed drop table part.

Please refer below code.

load Date#(Date,'DD-MM-YYYY') as Date;

load * inline

[Date

01-09-2018,

02-09-2018,

03-09-2018,

04-09-2018,

05-09-2018,

06-09-2018,

07-09-2018];

load Date, Previous(Date) as New_Date

Resident T

order by Date desc;