topic Re: logic Help ! in QlikView

logic Help !

ganeshreddy — Mon, 04 May 2015 06:37:07 GMT

Hi All,

How to get work period difference on particular day for each employee, for example take last three rows of employee number 102 ,there is more than one row for this combination on 29/04/2015, record the time difference between the last out punch of the previous row and the first in punch of the current row as the time between shifts. Here the time difference has to be in hour and minute combination. I am finding difficulty while calculating work period difference, please help me here. Please find the attached QVW.

Cheers,

Ganesh.

Re: logic Help !

Mon, 04 May 2015 10:58:49 GMT

Plz check this QVW. Hope this helps.

Re: logic Help !

ganeshreddy — Mon, 04 May 2015 12:56:08 GMT

Hi Ashish,

Thanks for your replay, Your logic is working fine in this QVW, But the same logic not working in my actual application.

Output coming as i mentioned in attached QVW. I can you identify reason why i am getting like that. PFA.

Cheers,

Ganesh

Re: logic Help !

ganeshreddy — Mon, 04 May 2015 13:04:26 GMT

Hi,

i mean output is coming like this if we apply filter Emp_ID as 107.

12:00:00 AM

12:25:00 AM

12:45:00 AM

02:25:00 AM

02:50:00 AM

04:30:00 AM

cheers,

Ganesh

Re: logic Help !

Wed, 06 May 2015 09:53:46 GMT

Hi in script instead of using this line :

Time(if(Previous([Emp ID]) = [Emp ID] and Previous(Date) = Date, Actual_In - Previous(Actual_Out),0)) as WorkPeriodDiff

format the time..

Time(if(Previous([Emp ID]) = [Emp ID] and Previous(Date) = Date, Actual_In - Previous(Actual_Out),0), 'hh:mm:ss') as WorkPeriodDiff