Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Find missing dates

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

6 Replies
Highlighted
Contributor III

Re: Find missing dates

Is there any criteria for absent Date ?

Highlighted
New Contributor III

Re: Find missing dates

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.

Highlighted
Partner
Partner

Re: Find missing dates

may you please elaborate on the following data that you have in the excel:

    

22435512/31/20153/1/20154/7/2015
22435512/31/20153/1/20153/10/2015
22435512/31/20153/1/20153/26/2015
22435512/31/20153/1/20154/4/2015
22435512/31/20153/1/20154/5/2015
22435512/31/20153/1/20154/6/2015
22435512/31/20153/1/20153/14/2015
22435512/31/20153/1/2015

3/1/2015

why you have repeated records for the same employee?

I can walk on water when it freezes
Highlighted
New Contributor III

Re: Find missing dates

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


Highlighted

Re: Find missing dates

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

Highlighted
Contributor III

Re: Find missing dates

How you find 16/04/2015 ?