is it possible to build time series processing in Qlik script?
My data consist of following tuples:
<Machine, TimeStamp, EventID?
EventID = set{1,.. 20} where EventID=20 indicates a fault
Machine = set{1,2,3} i.e. 3 machines are streaming data but it should be expandable.
I need to associate all events that precede a Fault within 30 second window. How do I associate all Faults with the events that precede within a certain time interval?
Database have windowing functions for this sort of thing.