topic How to Get Duration in Minute in QlikView

How to Get Duration in Minute

d4rlie891 — Wed, 07 Sep 2016 10:30:54 GMT

Hi,

Anyone can help me how to get the Duration in minutes ?

I want to get the duration in Minutes from Solved_Date_time - Start_Date_Time.

Thanks

Re: How to Get Duration in Minute

effinty2112 — Wed, 07 Sep 2016 15:39:03 GMT

Hi Darmawan,

Try:

=Interval(TimeStamp#(SOLVED_DATE_TIME) - TimeStamp#(START_DATE_TIME),'mm:ss')

which will give you the minutes and seconds.

If you just want minutes then:

=24*60*(TimeStamp#(SOLVED_DATE_TIME) - TimeStamp#(START_DATE_TIME)

Will give the minute which if you can round if needed.

Cheers

Andrew

Re: How to Get Duration in Minute

sunny_talwar — Wed, 07 Sep 2016 18:28:40 GMT

I think it would be good to read about how you can help Qlik Sense read your date fields correctly

Why don’t my dates work?

Get the Dates Right‌

Once you get your dates read correctly into Qlik Sense, you just need to use Interval function to get the values in Minutes

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/FormattingFunctions/Interval.htm‌

Re: How to Get Duration in Minute

d4rlie891 — Thu, 08 Sep 2016 02:19:12 GMT

Thanks Andrew and Sunny, from your information I can get the Minute with this formula :

24*60*(Timestamp(Timestamp#(SOLVED_DATE_TIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') - Timestamp(Timestamp#(START_DATE_TIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'))