topic Re: Find missing dates in QlikView

Find missing dates

suhaskharat — Wed, 16 Mar 2016 08:32:08 GMT

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

Re: Find missing dates

amayuresh — Wed, 16 Mar 2016 09:12:30 GMT

Is there any criteria for absent Date ?

Re: Find missing dates

suhaskharat — Wed, 16 Mar 2016 09:18:38 GMT

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.

Re: Find missing dates

ali_hijazi — Wed, 16 Mar 2016 09:22:21 GMT

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?

Re: Find missing dates

suhaskharat — Wed, 16 Mar 2016 09:33:33 GMT

As createdon dates are different for empid.

Re: Find missing dates

sunny_talwar — Wed, 16 Mar 2016 09:48:14 GMT

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

Re: Find missing dates

amayuresh — Wed, 16 Mar 2016 09:58:13 GMT

How you find 16/04/2015 ?