Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
davidvikings198
Contributor
Contributor

Above Function

Hi All,

I have the following information in a table:

  

Sysif(IsNull(above(Sys)),0,Sys-Above(Sys))
8/24/2018 8:270
8/24/2018 8:510
8/24/2018 8:510
8/24/2018 8:590
8/24/2018 9:32

0

I have the formula I am using where I want a running total but it is not working.  I would like it to show as time like:

00:00:00

00:00:09

00:00:01

00:00:08

00:00:33

I hope this makes sense.  All suggestions would be helpful.

David

1 Reply
petter
Partner - Champion III
Partner - Champion III

You should refrain from posting the same question multiple times (so called cross posting).

Here is an answer to your question in your identical post:

Above Function