Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Get the EndDate from Next StartDate

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

4 Replies

Re: Get the EndDate from Next StartDate

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,

Regards,
Prashant Sangle
florentina_doga
Contributor III

Re: Get the EndDate from Next StartDate

see this attach

Not applicable

Re: Get the EndDate from Next StartDate

thank you

Not applicable

Re: Get the EndDate from Next StartDate

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