Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
i have an excel attached which have fields first working date and last working date of employees and createdon as present date of that particular employee so i want to find the absent dates in scripting please help
Is there any criteria for absent Date ?
for empid 224580 first working date 01/03/2015 and last working date is 19/04/2015 so we have createdon date of all days from fisrt to last working dates but he is abesent on 16/04/2015. so i want to have that particular date for this empid as other field.
may you please elaborate on the following data that you have in the excel:
224355 | 12/31/2015 | 3/1/2015 | 4/7/2015 |
224355 | 12/31/2015 | 3/1/2015 | 3/10/2015 |
224355 | 12/31/2015 | 3/1/2015 | 3/26/2015 |
224355 | 12/31/2015 | 3/1/2015 | 4/4/2015 |
224355 | 12/31/2015 | 3/1/2015 | 4/5/2015 |
224355 | 12/31/2015 | 3/1/2015 | 4/6/2015 |
224355 | 12/31/2015 | 3/1/2015 | 3/14/2015 |
224355 | 12/31/2015 | 3/1/2015 | 3/1/2015 |
why you have repeated records for the same employee?
As createdon dates are different for empid.
for empid 224580 first working date 01/03/2015 and last working date is 19/04/2015 so we have createdon date of all days from fisrt to last working dates but he is abesent on 16/04/2015. so i want to have that particular date for this empid as other field.Any how repetative for repeated empid may also work
How would you do the calculations outside QlikView? I guess what i am trying to understand is what is your expected output?
How you find 16/04/2015 ?