topic Re: How to get the next value in QlikView

How to get the next value

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

Hi,

I have this set of data:

OPERATOR DATE

Andrew 06/02/2018 08:35:41

Andrew 06/02/2018 08:37:12

Andrew 06/02/2018 08:41:01

I would like to add a new column to display the next value, like this:

OPERATOR DATE NEXT

Andrew 06/02/2018 08:35:41 06/02/2018 08:37:12

Andrew 06/02/2018 08:37:12 06/02/2018 08:41:01

Andrew 06/02/2018 08:41:01 .....

I've tried with Peek without success

Thank you in advance

Re: How to get the next value

prat1507 — Thu, 22 Feb 2018 14:42:46 GMT

Maybe this

Tab:

LOAD * Inline [

OPERATOR, DATE

Andrew, 06/02/2018 08:35:41

Andrew, 06/02/2018 08:37:12

Andrew, 06/02/2018 08:41:01

];

NoConcatenate

Tab1:

LOAD RowNo() as Rno,*

Resident Tab;

Drop Table Tab;

Left Join

LOAD Rno-1 as Rno,DATE as NEXTDATE Resident

Tab1;

Re: How to get the next value

alexandros17 — Thu, 22 Feb 2018 14:49:32 GMT

Try This:

AAA:

LOAD * Inline [

OPERATOR, DATE

Andrew, 06/02/2018 08:35:41

Andrew, 06/02/2018 08:37:12

Andrew, 06/02/2018 08:41:01

];

BBB: NoConcatenate

LOAD * Resident AAA Order by DATE Desc;

DROP Table AAA;

CCC: NoConcatenate

LOAD OPERATOR, DATE, Previous(DATE) as Next_DT Resident BBB;

DROP Table BBB;

Re: How to get the next value

Brownie — Mon, 31 Oct 2022 07:30:54 GMT

Heyy

what if i want todays date as well in the middle. i want my data to be like this