Get the EndDate from Next StartDate

[#1]

Hello,

I have a table with the date below.What I try to do is to
add a [EndDate] field and fill the value with date which the date
before the same [MachineCode]'s [StartDate].

In the SQL I can reload the same table severl times to make join and
[ON] or sth like that. But I have no idea how to make that in the QlickView.

Thanks

[PrashantSangle]

Hi,

In qlikview also you can load same table multiple times.

or whatever logic you are doing in sql you can directly use that query in qlikview.

Regards,

[florentina_doga]

see this attach

[#4]

thank you

[#5]

thank you ! I'll try to understand the script and It looks like what just I'm finding!