Each registration got all the pauses instead of the token one

[Anonymous]

Dear Qlik Community,

Here's a repost of mine question I have been stucked for like one week. I hope someone has a solution for this problem.

In our database we have this table:

Where:

F0143 = DATE

F0494 = TIME in seconds

F0579 = kind of activity

01 is start work

02 is start pause

03 is end pause

The second table we have:

F0323 = key employee

F0585 = key activity

So one employee can have more activities in one day. We want to know how much time he spend on each activity without pause. We can't fix this because of the following problem:

Each day has 7 standard registration for a employee

Start work (7:00)

pauses (10 till 10:20, 13 till 13:45, 15:00 till 15:20)

So if a employee started at 7:00 a activity and another one (so he ends the first) at 10:30 we want the time he spend one the first activity. In this case that has te be 10:30 - 7:00 = 2:30, 2:30 - 0:20 (pause)= 2:10. We dont know how te write the script i hope someone can help us.

Kinds Regards,

Beginner Martijn

[MarcoWedel]

please post your sample data in a format that can be loaded in QlikView.

thanks

regards

Marco

[Anonymous]

Hi Marco,

Here is our sample data

[MarcoWedel]

this data doesn't match your description