Find missing dates

[suhaskharat]

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

[amayuresh]

Is there any criteria for absent Date ?

[suhaskharat]

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.

[ali_hijazi]

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?

[suhaskharat]

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

[sunny_talwar]

How would you do the calculations outside QlikView? I guess what i am trying to understand is what is your expected output?

[amayuresh]

How you find 16/04/2015 ?