Window functions to create custom warnings

[Pankhudri20]

Hello,

Hope everyone is doing well and safe!

I am required to process large amounts data in excel files which are generated every 15 seconds.

I am looking to create custom warnings.

Example warning, "if amplitude <1 lasts 1 hour". (1 hour is dynamic, it can change every few months, can become 2 hours or anything else)

I have columns for amplitude like Amp1, Amp2... till Amp 22. 

I have the data log with date and time format: mm/dd/yyyy hh:mm:ss

It should return the timestamp and which amplitude number it belongs to. For example Amp1 or Amp2 or....

The warnings should be displayed on the dashboard(in qlik) and in an email.

Can you please tell how can I achieve this?

Any help would be greatly appreciated.

Thank you

Regards,

Pankhudri

[BrandonB]

Can you provide some sample data? It would probably be easiest to use a multi field tool for the calculations and then possibly a test tool if you are looking to have it throw an actual error or warning if a condition isn't met. 

[Pankhudri20]

Hello @BrandonB 

Thank you for your response.

I have created a small sample file for your reference.

C1, C2, C3...C11 are the cell numbers required in the warnings.

warning condition:

if amp <1 lasts 1 hour (1 hour is a dynamic number, can change)

Any help would be greatly appreciated.

Thank you

Regards,

Pankhudri