Need Help creating a report

Thu, 03 Jan 2013 13:19:33 GMT

Hi, I need a little of help creating a report

I want to create a report that compare and show what person was not available in a day.

I have two tables one is a master that have all the people and another one that have the assistant (have name, id, date and hour, etc.)

I want to create a report by date, week, and month

I will appreciate all your help.

MASTER

ID	NAME	LNAME	OFFICE
001	JOSE	DIAZ	002
002	MARIA	LOPEZ	001
003	JOHN	QUE	001
004	LUI	BOCH	003
005	PETER	PAN	001

ASSISTANCE

ID	ENTER	EXIT	HOUR
001	1/1/2013 10:00	1/1/2013 15:00	5
002	1/1/2013 10:00	1/1/2013 15:00	5
003	1/1/2013 10:00	1/1/2013 15:00	5
004	1/1/2013 10:00	1/1/2013 15:00	5
005	1/1/2013 10:00	1/1/2013 15:00	5
001	1/2/2013 10:00	1/2/2013 15:00	5
002	1/2/2013 10:00	1/2/2013 15:00	5
004	1/2/2013 10:00	1/2/2013 15:00	5
005	1/2/2013 10:00	1/2/2013 15:00	5
001	1/3/2013 10:00	1/3/2013 15:00	5
002	1/3/2013 10:00	1/3/2013 15:00	5
003	1/3/2013 10:00	1/3/2013 15:00	5
004	1/3/2013 10:00	1/3/2013 15:00	5
001	1/4/2013 10:00	1/4/2013 15:00	5
003	1/4/2013 10:00	1/4/2013 15:00	5
005	1/4/2013 10:00	1/4/2013 15:00	5

What I need:

What are the people that don’t assist on a date.

Re: Need Help creating a report

Thu, 03 Jan 2013 18:59:42 GMT

I will appreciate any help

Thanks

Re: Need Help creating a report

rwunderlich — Thu, 03 Jan 2013 20:47:47 GMT

It somewhat depends on how exactly you want to display the results. The attached example will create a Worked =Y/N flag for every combination of ENTER dates and ID. You can use that as a filter.

-Rob

Re: Need Help creating a report

Thu, 03 Jan 2013 21:20:06 GMT

Thanks it realy helps a lot

topic Re: Need Help creating a report in QlikView

Need Help creating a report

Re: Need Help creating a report

Re: Need Help creating a report

Re: Need Help creating a report