Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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;
In this case you want below(start)
exactly it's what i wan't
you know how to do that in the script?
please help me the below function is ok but not in the script!
How can i do that in the script???
Thanks everybody
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;
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.
congratulation and thank you it resolve my problem!!!!!!
Have a good day