Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
kakani87
Valued Contributor

Calcualte time in between Out and In

Hi Every one ....

I'm having biometric data containing employee  sign in and out time but now i want to display the time between out and in  break time duration.

could any one help me to find out this.

PFA.

8 Replies
Highlighted
michaelblackbur
New Contributor III

Re: Calcualte time in between Out and In

Try this;


=interval( TIMEFIELD2 - TIMEFIELD1, 'hh:mm')

Highlighted
kakani87
Valued Contributor

Re: Calcualte time in between Out and In

Michael .... this is working for total time spent in a day but i want for in between out and In duration for breaks in a day here this is not working.

Could you kindly have a look into my attachment and help me out of this issue

Highlighted

Re: Calcualte time in between Out and In

Which table are you working with and what is that you expect to see (what are you seeing and what do you want to change)?

Highlighted

Re: Calcualte time in between Out and In

May be this?

Date(Aggr(Timestamp(MinString({<InOut={'0'}>}SignIn))-Timestamp(MaxString({<InOut={'1'}>}SignOut)), tran_date,EmpName),'hh:mm:ss TT')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
kakani87
Valued Contributor

Re: Calcualte time in between Out and In

Hello Sunny ...

Below the Employee access table there is a table displayed as IN

In that every out and in break time to be displayed for all employees like how much time they are out from seats

Highlighted
kakani87
Valued Contributor

Re: Calcualte time in between Out and In

Sunny If we scroll little down we can see for employee IN and OUT Access time entries properly in a day

@Sunny Talwar

Highlighted

Re: Calcualte time in between Out and In

So what do you expect to see here? (Which column? What numbers)

Highlighted
kakani87
Valued Contributor

Re: Calcualte time in between Out and In

Employee wise Break time for example,

an empployee is out on 11:0000 amand In on 11:30:00 am

Now the break time is 00:30 - mins

That should be displayed in the chart i mentioned last table

mentioned as 'IN' below Employee Access Details table

the other are for test purpose i have entered they are negligible

emp       Signin        signout      Break time

SAI       10:00:00 am   11:00:00 am  00:30:00 TT

SAI       11:30:00 am               

@Sunny Talwar.