topic Re: Load records depending on specific preceding records in QlikView

Load records depending on specific preceding records

pennetzdorfer — Wed, 28 Aug 2013 16:36:28 GMT

Hey,

I'm analyzing some of our system logfiles in order to identify bottlenecks. My (simplified) data model contains the fields ItemID, ActionType and Timestamp.

The issue:

For each ItemID I would like to extract the Timestamp of the first occurence of ActionType A - under the condition that there already has been a preceding ActionType D (red records).

Please note that I need to do that in script! I would like to create a new table that should look like this:

Please find the attached qvw.

Thanks in advance!

Regards, Florian

Re: Load records depending on specific preceding records

Gysbert_Wassenaar — Wed, 28 Aug 2013 16:58:21 GMT

See attached qvw

Re: Load records depending on specific preceding records

arthur_dom — Wed, 28 Aug 2013 17:12:31 GMT

I think you could do something like this: <attached>

Re: Load records depending on specific preceding records

pennetzdorfer — Thu, 29 Aug 2013 09:21:34 GMT

Thanks a lot!

Is it also possible to do the "converse": extract the Timestamp of the last occurence of Action A before the first occurrence of Action D? (please see red lines)

Thanks!