topic Re: Split Time in QlikView

Split Time

zturaiki — Mon, 07 Jan 2013 15:32:20 GMT

Hi ..

i have this table :

i want to split the time in and time out .

so the user can see the employee who check in between (9:00 - 9:30) or between (9:30 - 10) ..... so on ..

how to do it ?

swuehl — Mon, 07 Jan 2013 16:06:01 GMT

Not quite sure if I've understood your request properly, could you post your requested result, too?

Maybe this might help you:

wms_manis — Mon, 07 Jan 2013 16:16:51 GMT

You can use interval match to handle this.

I used every hour in my attached example.

Here is the script:

SET TimeFormat='h:mm';

Time:

LOAD

RowNo() as Row,

maketime(RowNo()-1) as Time

autogenerate 24;

EmpLog:

LOAD * INLINE [

Employee, CheckIn, Checkout

1, 9:30, 12:00

2, 15:00, 21:05

3, 8:30, 9:00

5, 7:30, 23:02

6, 5:35, 8:30

];

IntervalMatch(Time) Load CheckIn,Checkout Resident EmpLog;