topic Problem whith follow line in QlikView

Problem whith follow line

Tue, 13 Nov 2012 09:33:51 GMT

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!

Re: Problem whith follow line

Gysbert_Wassenaar — Tue, 13 Nov 2012 09:44:13 GMT

In this case you want below(start)

Re: Problem whith follow line

Tue, 13 Nov 2012 09:47:18 GMT

exactly it's what i wan't

Re: Problem whith follow line

Tue, 13 Nov 2012 09:50:59 GMT

you know how to do that in the script?

Re: Problem whith follow line

Tue, 13 Nov 2012 10:23:28 GMT

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

How can i do that in the script???

Thanks everybody

Re: Problem whith follow line

Gysbert_Wassenaar — Tue, 13 Nov 2012 11:27:54 GMT

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;

Re: Problem whith follow line

Tue, 13 Nov 2012 11:48:41 GMT

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.

Re: Problem whith follow line

Tue, 13 Nov 2012 12:00:43 GMT

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

Have a good day