Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatbza
Creator
Creator

How to find out the hours between the days

Hi Friends,

I have two timestamps and need to find out the hours between that timestamps. Please help me how to find.

timestamp 1)      2017-07-21 21:00:00

timestamp 2)      2017-07-24 15:50:48

Thanks,

Venakt

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

SET TimestampFormat='YYYY-MM-DD hh:mm:ss';

Data:

Load T1, T2 Inline

[

T1, T2

2017-07-21 21:00:00,2017-07-24 15:50:48

];

=Interval(T2-T1)*24

View solution in original post

3 Replies
Chanty4u
MVP
MVP

try this

=interval(Filed1- Field2, 'hh')

MK_QSL
MVP
MVP

SET TimestampFormat='YYYY-MM-DD hh:mm:ss';

Data:

Load T1, T2 Inline

[

T1, T2

2017-07-21 21:00:00,2017-07-24 15:50:48

];

=Interval(T2-T1)*24

YoussefBelloum
Champion
Champion

Hi,

try this:

=Interval(Timestamp2-timestamp1,'HH')