Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

garry107
New 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)