Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
garry107
Contributor
Contributor

duration of dates on a certain condition

Hi,

I have a small requirement. I have the below table of just Timestamp  and value. Want to calculate the highlighted column.  in script

TImestamp                          |     Value                       Duration

3/18/2019 11:08:00               10                                  -

3/18/2019 11:08:01               111                               1 sec

3/18/2019 11:08:02               121                                - 

3/18/2019 11:08:03               70                                   -

3/18/2019 11:08:04               122                                  2 sec

3/18/2019 11:08:05               1000                              -

3/18/2019 11:08:06               1118                              -

 

Basically wanted to calculate Highlighted Duration - Interval of Timestamp from start to end timestamp whenever value is greater than 100.

 

Thanks,

Garry

Labels (2)
0 Replies