# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Partner

## qlikview date/time

formula to calculate correct duration please (as per screenshot):

note, the figures for duration in the screenshot are incorrect because they fai to take into account the rolling over into another day.

1 Solution

Accepted Solutions
MVP & Luminary

If you export this table to excel you will see that the calculation will be right but Qlik displayed only the time-part. To display also the days you could use: interval(End - Start, 'D hh:mm:ss'). And you need to enable expression-standard within the tab numbers.

- Marcus

7 Replies
MVP

I think you need to use TimeStamp fields which have dates in them to find the difference and then use Interval function to get the duration

Interval([Seq No. End Date] - [Seq No. Start Date], 'hh:mm:ss')

MVP

May be like this?

Interval( Date1-Date2, 'hh:mm:ss')

Perhaps this?

Interval(TimeStamp#([Seq No. End Date]) - TimeStamp#([Seq No. Start Date]), 'hh:mm:ss')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP & Luminary

If you export this table to excel you will see that the calculation will be right but Qlik displayed only the time-part. To display also the days you could use: interval(End - Start, 'D hh:mm:ss'). And you need to enable expression-standard within the tab numbers.

- Marcus

Partner
Author

Thanks Marcus.

... but how can I format 1 04:30:00 to be 28:30:00 ?

MVP

Instead of using the format 'D hh:mm:ss', use 'hh:mm:ss'

Partner
Author

Thanks Sunny.

Community Browser