Discussion Board for collaboration on QlikView Scripting.
I'm analyzing some of our system logfiles in order to identify bottlenecks. My (simplified) data model contains the fields ItemID, ActionType and Timestamp.
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!
Go to Solution.
See attached qvw
I think you could do something like this: <attached>
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)