Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
venkatbza
New Contributor III

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
Highlighted
MVP
MVP

Re: How to find out the hours between the days

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
Highlighted
Chanty4u
Esteemed Contributor III

Re: How to find out the hours between the days

try this

=interval(Filed1- Field2, 'hh')

Highlighted
MVP
MVP

Re: How to find out the hours between the days

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

Highlighted
YoussefBelloum
Esteemed Contributor

Re: How to find out the hours between the days

Hi,

try this:

=Interval(Timestamp2-timestamp1,'HH')