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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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