Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Time Series sequnece processing in Qlik script

Hello experts,

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.

0 Replies