Grouping the data

vlad_komarov — Wed, 26 Jan 2011 19:35:26 GMT

Hello,

I have a data table that contains set of events (Enter and Exit) and corresponding date stamps for each one of them.

This is an example of RAW data:

Each ID handles at least one pair of events per day (for example for ID = 3215028):

I need to calculate the difference between Exit and Enter event per ID per period of time.

I was trying to group these records together during the data load, but was unable to do so.

What's the best way to do it? I would appreciate an expert suggestion.

Best regards,

Wed, 26 Jan 2011 20:49:30 GMT

Hi,

Hope i have understood your question.

Pl look at the attached application.

In my application i have seggregated "Event Date Time" into two time like Enter_Time and Exit_Time using Peek() function.

Hope this helps you.

- Sridhar

vlad_komarov — Fri, 28 Jan 2011 00:31:26 GMT

Thanks! I've used your approach and my script is working properly now.

Regards,

topic Grouping the data in QlikView