Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna4bo
Creator
Creator

Calculating time diff

Hi All,

How to Calculate time diff .

Ex: To-From as Duration

    

Thanks,

Krishna

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

PFA!

=interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Regards,

AS

View solution in original post

3 Replies
amit_saini
Master III
Master III

PFA!

=interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Regards,

AS

View solution in original post

krishna4bo
Creator
Creator
Author

Hi Amit,



How to Calculate 24 - interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')


Thanks,

Krishna

amit_saini
Master III
Master III

Like this???

=interval(time('24:00:00', 'hh:mm:ss')-

interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss'))

Thanks,

AS