I am working on Employee Attendance data. The attendance data has Employee Id, Attendance date, Date & Time In and Date & Time Out.
My requirement is to make a table where I list all the hours when an Employee is present. That means if an employee punches in at 8Am and Punches out at 5PM; I need the below hours in my employee attendance hours table:
When I write the code; I use the Peek function in a do while loop at it takes more than an hour to parse 100 thousand records. Is there any workaround to speed up the code?
You should describe your problem trully, without leaving any details out; I don't understand why you did noy try to extended the application I attached (Z_Attendance_01.qvf) one of the Qlik Community functions is to guide developers like you to understand and learn the product; this is not a "Hire a Qlik Developer" Community, if that is what you are looking for, post your question in those sites the offer "Developers for Hire".
Now going back to your question, as I already upload the application: Z_Attendance_01.qvf Would you please ask a question based on where in its script you are experiencing difficulties? or clearly ask for the application to be fully written for you?
Arnaldo Sandoval A journey of a thousand miles begins with a single step.