topic Re: qlikview date/time in QlikView

qlikview date/time

wade12 — Tue, 09 Jan 2018 12:25:05 GMT

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.

Re: qlikview date/time

sunny_talwar — Tue, 09 Jan 2018 12:27:12 GMT

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

Re: qlikview date/time

tresB — Tue, 09 Jan 2018 12:28:39 GMT

May be like this?

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

Re: qlikview date/time

Anil_Babu_Samineni — Tue, 09 Jan 2018 12:29:36 GMT

Perhaps this?

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

Re: qlikview date/time

marcus_sommer — Tue, 09 Jan 2018 12:31:05 GMT

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

Re: qlikview date/time

wade12 — Tue, 09 Jan 2018 13:58:15 GMT

Thanks Marcus.

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

Re: qlikview date/time

sunny_talwar — Tue, 09 Jan 2018 14:03:18 GMT

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

Re: qlikview date/time

wade12 — Tue, 09 Jan 2018 14:10:22 GMT

Thanks Sunny.