ABOVE Function

[roee1983]

Dear All,

I'm Trying to use Above Function to calculate dif between hours.

Please Help me

attched:

ID	Hour	Diff
1	08:12:20	0
2	08:10:20	2

Thank u all

Roee

[MindaugasBacius]

I am not sure how your data model looks that's why I have created the back-end version:

tmp:

LOAD ID,

     Time(Hour) as Hour,

     Diff

FROM

[https://community.qlik.com/thread/319275]

(html, codepage is 1257, embedded labels, table is @1);

NoConcatenate

tmp2:

LOAD *

Resident tmp

Order By ID

;

DROP Table tmp;

tmp:

LOAD *

,Peek(Hour) - Hour  as New_diff

Resident tmp2;

DROP Table tmp2;

The output:

!

[sunny_talwar]

You are looking to do this on the front end? What is the issue that you are running into when you use Above() function?

[Frank_Hartmann]

Straight Table:

Dim:

ID

Expression1:

Hour

Expression2:

Interval(Above(Hour)-Hour,'hh:mm:ss')