Problem whith follow line

[#1]

Hello everybody,

I have a "simple" question in qlikview i have this tab:

I want a variable ("End") who takes the follow date to calculate the duration of PROGR_OPERAZ like this:

I know the 'Previous' expression but i don't know how to take the next expression!

Any idea?

Thank a lot everybody!

[Gysbert_Wassenaar]

In this case you want below(start)

[#3]

exactly it's what i wan't

[#4]

you know how to do that in the script?

[#5]

please help me the below function is ok but not in the script!

How can i do that in the script???

Thanks everybody

[Gysbert_Wassenaar · Accepted solution]

This should do the trick:

TempTable:

Load

serial_number,

progr_operaz,

Start

from ....etc;

Table:

Load *,

peek('Start') as End

resident TempTable

order by serial_number, Start desc;

drop table TempTablel;

[#7]

You can´t use bellow() in Script .

there´s a little bug at you´re table, on line 13 the End time is smaller than the Start time 😃

i don´t know if it works, but you can try to create the variable with an if() statment where you use the RowNo() and the ColumNo() function, there you can define to take the value from the next row and colum.

I don´t have time to try it, sorry.

[#8]

congratulation and thank you it resolve my problem!!!!!!

Have a good day