Qlik Community

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 
Search instead for 
Did you mean: 
wade12
Partner
Partner

qlikview date/time

quick question please, any/all advices appreciated, thank you in advance.

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
marcus_sommer
MVP & Luminary
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

View solution in original post

7 Replies
sunny_talwar

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')

tresesco
MVP
MVP

May be like this?

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

Anil_Babu_Samineni

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)
marcus_sommer
MVP & Luminary
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

View solution in original post

wade12
Partner
Partner
Author

Thanks Marcus.

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

sunny_talwar

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

wade12
Partner
Partner
Author

Thanks Sunny.