Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
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.
View solution in original post
Thanks! I've used your approach and my script is working properly now.