Analyzing 2 rows of data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I have a problem, I would like to analyze my data 2 by 2 rows.

Time

EventId

Type

15-06-2009T13:45:30

End_Time

15-06-2009T13:45:34

Something

This is my data. For example, we have id of an operation, End_Time of an operation, EventId etc. and it is an consequent Event for the same operation. I would like to get the Count of id, which have started with EventId = 1 and Type = 'End_Time' and consequent action with EventId = 4, but the maximum difference between time should be 5 seconds.

I attach excel file with more data but imagine there are many types of EventId and Type.

Regards,

Todor

Re: Analyzing 2 rows of data

stigchel — Tue, 24 Oct 2017 16:11:51 GMT

I would add a field on the same row for EventId=1 with the subsequent time for EventId=4 and flag the records that are 5 seconds or less. Something like attached. Depending on your other needs/datamodel you can add other fields and/or rows

topic Re: Analyzing 2 rows of data in QlikView

Analyzing 2 rows of data

Re: Analyzing 2 rows of data