topic Re: Look at the previous value and next value of the row in QlikView

Look at the previous value and next value of the row

Wed, 11 May 2016 15:45:46 GMT

Hello experts,

I am currently working on a problem in which I want to look at the previous value of the row and which I can achieve by using Peek function. How can I look at the next value at the same time?

I want to be able to look at both at the same time. Please let me know if you need any more information. Greatly appreciate your help.

Thank you,

Parth

Re: Look at the previous value and next value of the row

santiago_respane — Wed, 11 May 2016 15:53:56 GMT

Hi Path,

you can achieve this using the Peek function using its parameters like this:

peek( 'Sales',-1 ) - returns the value of Sales in the previous record read ( equivalent to previous(Sales) ).

peek( 'Sales', 1 ) - returns the value of Sales from the second record read from the current internal table.

Hope this helps.

Kind regards,

Re: Look at the previous value and next value of the row

Wed, 11 May 2016 15:59:36 GMT

Hi Santiago,

Thank you for your response.

I m confused now. Would you please verify my two statements below?

If I am at row 1000,

Peek('Sales',-1) --> does it look at row 999?
Peek('Sales',1) --> does it look at row 1001?

Thank you very much for your help.

Best,

Parth

Re: Look at the previous value and next value of the row

settu_periasamy — Wed, 11 May 2016 16:24:40 GMT

Hi Parth,

For 2nd Point,

The data for the Peek() function is loaded from the previously loaded table in the associative QlikView database.

Peek() or Previous() ?

Re: Look at the previous value and next value of the row

krishnacbe — Wed, 11 May 2016 16:29:18 GMT

Yes your assumption is right.

Both will be working on top of loaded tables.

Re: Look at the previous value and next value of the row

santiago_respane — Wed, 11 May 2016 17:41:39 GMT

Here you have an example:

TABLE_AUX:

load * inline [

a,b

r,1

s,2

t,3

u,4

x,5

y,6

z,7

];

TABLE_FINAL:

LOAD

a, b,

PREVIOUS(b) as PREV,

PEEK('b',RowNo(),'TABLE_AUX') as NEXT

RESIDENT TABLE_AUX;

DROP TABLE TABLE_AUX;

Please tell if this suits your needs.

Kind regards,

Re: Look at the previous value and next value of the row

Charles_Alter-SI — Thu, 16 Apr 2020 21:18:26 GMT

Hello,

I had the issue with log ordered by date (I wanted to compare the timestamp to the next). I find a simple solution was to order the table by Date desc;

Fait :
NoConcatenate
Load
Flg_TP,

id_objet,
if(Previous(id_objet)=id_objet, Previous(Date_et_heure)-Date_et_heure,0) as Duration,
Date_et_heure
Resident Fait_tmp order by id_objet,Date_et_heure desc;