Calculate values for "End Date"

[ZuhaibRana]

I want to calculate values for "End Date" 

"Employee ID" 1  join IT dept in jan-95

after this "Employee ID" 1 leave the IT dept and join Sales dept in dec-05 so 31-11-2015 end date of employee 1 in IT dept

like this i want to calculate all employee end date

[RafaelBarrios]

Hi @ZuhaibRana 

Try this in script

load

[Employee ID],
[Dept ID],
[Dept Name],
[Start Date],
If([Employee ID]=previous([Employee ID]),previous([Start Date])) as [End Date]
from Your_table_here
Order by [Employee ID],[Start Date] desc;

You could also try

If([Employee ID]=previous([Employee ID]),peak([Start Date])) as [End Date]

it could have some syntax error as I couldn’t tried it, but I hope you get the idea.

hope this helps.

best,

Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

[robert99]

Check out this post

Solved: Re: Calculate End date from the start date of the ... - Qlik Community - 1997535