topic Re: ABOVE Function in QlikView

ABOVE Function

roee1983 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 08 Nov 2018 08:23:40 GMT

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

(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 — Thu, 08 Nov 2018 11:25:57 GMT

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 — Thu, 08 Nov 2018 11:42:54 GMT

Straight Table:

Dim:

Expression1:

Hour

Expression2:

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