Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
!
You are looking to do this on the front end? What is the issue that you are running into when you use Above() function?
Straight Table:
Dim:
ID
Expression1:
Hour
Expression2:
Interval(Above(Hour)-Hour,'hh:mm:ss')