Timestamp to minutes

DerekTomps — Mon, 01 Nov 2021 14:15:54 GMT

Hi,

This expression currently returns a timestamp. However, I am trying to convert the following script expression in to total number of minutes so I can then divide this by a number of moves as a productivity measure.

IF(operator_name = PREVIOUS(operator_name) AND type_description = 'UNAV' AND PREVIOUS(type_description) <> 'UNAV' and che_name = previous(che_name)
or operator_name = PREVIOUS(operator_name) AND type_description = 'LGOF' AND PREVIOUS(type_description) <> 'UNAV' and che_name = previous(che_name)
or operator_name = PREVIOUS(operator_name) AND type_description = 'LGON' AND PREVIOUS(type_description) = 'AVAL' and che_name = previous(che_name),
interval(timestamp - PREVIOUS(timestamp)),'hh:mm')&' '& date(date#(left(date(Floor([timestamp])),40),'DD/MM/YYYY')), timestamp(timestamp) AS Loggedin

However, I am drawing a blank and would really appreciate some help.

Regards

Derek

Re: Timestamp to minutes

rwunderlich — Mon, 01 Nov 2021 17:18:14 GMT

Assuming the field "timestamp" is a proper Qlik datetime -- it appears it is from your example.

timestamp - Previous(timestamp)

returns the difference as integer number of days and fractional part of a day. You have two choices to convert this to minutes.

(timestamp - Previous(timestamp))* 1440. // Multiply by #minutes in a day

Num#(Interval(timestamp - Previous(timestamp), 'm')) // Get Interval minutes and convert the text to number

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

topic Re: Timestamp to minutes in App Development

Timestamp to minutes

Re: Timestamp to minutes