topic Re: Re: Read next row peek() in QlikView

Re: Read next row peek()

tresB — Tue, 06 May 2014 06:37:42 GMT

See the front end solution attached.

Re: Read next row peek()

SunilChauhan — Tue, 06 May 2014 06:39:07 GMT

use

below(FECHAESTA)

in New Field Expression

hope this helps

Re: Re: Read next row peek()

Tue, 06 May 2014 06:47:21 GMT

PFA.

Re: Read next row peek()

jagan — Tue, 06 May 2014 06:52:14 GMT

Hi,

If you need this in script try like this

Temp:

LOAD NUMERO,

PASO,

ESTATUS,

FECHAESTA

FROM

[DATA.xlsx]

(ooxml, embedded labels, table is status);

Data:

LOAD

Previous(FECHAESTA) AS NextDate

RESIDENT Temp

ORDER BY NUMERO DESC, PASO DESC;

Drop table Temp;

Regards,

jagan.

Re: Read next row peek()

dcd123456 — Tue, 06 May 2014 12:21:59 GMT

Hello

if i use a qvd file instead an excel file, the peek function don't work.

is there any diferences using excel file or qvd files like source data to use peek function??

Re: Read next row peek()

dcd123456 — Tue, 06 May 2014 12:32:41 GMT

it works

thanks

regards

diego

Re: Read next row peek()

anbu1984 — Tue, 06 May 2014 14:00:36 GMT

If you want to use Peek, replace Previous by Peek in Jagan's code

Temp:

LOAD NUMERO,

PASO,

ESTATUS,

FECHAESTA

FROM

[DATA.xlsx]

(ooxml, embedded labels, table is status);

Data:

LOAD

Peek(FECHAESTA) AS NextDate

RESIDENT Temp

ORDER BY NUMERO DESC, PASO DESC;

Drop table Temp;

Re: Read next row peek()

dcd123456 — Tue, 06 May 2014 14:08:01 GMT

Hello

why the peek() function don't work if i read the same data from a QVD instead an excel file?

data:

LOAD NUMERO,

PASO,

ESTATUS,

FECHAESTA

FROM

DATA.xlsx

(ooxml, embedded labels, table is status);

NoConcatenate

data1:

load *

resident

data

order by ESTATUS,FECHAESTA,NUMERO asc;

data2:

load

NUMERO,

PASO,

ESTATUS,

FECHAESTA,

peek('FECHAESTA',recno(),'data1') as newfield

resident data1;

thanks

regards

diego

Re: Read next row peek()

anbu1984 — Wed, 07 May 2014 05:28:16 GMT

You missed sorting on field Paso and peek function is not correct. Try this

[data]:

LOAD * INLINE [

NUMERO,PASO,ESTATUS,FECHAESTA

2000000000,1,0,04/03/2013

2000000000,2,2,20/03/2013

2000000000,3,9,22/03/2013

];

NoConcatenate

data1:

load *

resident

data

order by NUMERO asc,PASO desc,ESTATUS,FECHAESTA;

Drop table data;

data2:

load

NUMERO,

PASO,

ESTATUS,

FECHAESTA,

peek(FECHAESTA) as newfield

resident data1;

NUMERO	PASO	ESTATUS	FECHAESTA	New Field
2000000000	1	0	04/03/2013	20/03/2013
2000000000	2	2	20/03/2013	22/03/2013
2000000000	3	9	22/03/2013