topic All Dates Required in QlikView

All Dates Required

tresB — Thu, 07 Oct 2010 10:49:54 GMT

Hi All,

I have a basic and common issue. I need to show the attendance of the employees date-wise. The database captures the records using bio-metric system. So there are no data of the employees for the absent days. I need to show those days even in the reporting as absent - days. I have created a common calendar which has all date dates, but now i am not finding any easy way out for the reporting. Please help with your valuable inputs.

Thanks & regards,

tresesco

All Dates Required

tresB — Fri, 08 Oct 2010 06:15:29 GMT

Hi All,

Please have a look at this issue.

All Dates Required

renjithpl — Fri, 08 Oct 2010 11:09:14 GMT

Can you send a sample structure of your table. ?

All Dates Required

tresB — Fri, 08 Oct 2010 11:34:09 GMT

Hi Ranjit, Here is some idea of data and what i want..

Emp ID	Attendance	Output for Emp ID =1
1	1/2/2010
2	1/2/2010	Emp ID	Date	Att_Status
3	1/2/2010	1	1/2/2010	Pr
4	1/2/2010	1	2/2/2010	Ab
2	2/2/2010	1	3/2/2010	Ab
3	2/2/2010	1	4/2/2010	Ab
4	2/2/2010	1	5/2/2010	Pr
1	5/2/2010
2	5/2/2010

All Dates Required

Fri, 08 Oct 2010 11:54:29 GMT

Cant your simply select show null values for the dimension?

or if null create a value?

All Dates Required

tresB — Fri, 08 Oct 2010 12:31:13 GMT

Hi Chris,

Thanks for your interest. But the matter is - there is no data for some dates in between, so we can't simply say that if NULL then do this(because we need to tell that NULL against which Field...and there is no field value for those dates). For that we have to make a common calendar which contains all tha dates(which i have done). But again, after that, those dates are required to be associated with all Employee IDs. Then only we can associate the exsisting DATEs with the common calendar Dates. What i found is a bit lenghty and probably not optimised way. I am expecting a better solution in your expert inputs.

Thanks & Regards,

tresesco