topic Re: Calculate Minutes between two times - not working in QlikView

Calculate Minutes between two times - not working

prees959 — Fri, 22 Sep 2017 18:14:42 GMT

Hi,

Im trying to calculate the minutes between two datetime fields - but it is showing 00:00 for every record.

My calculation is :

time(

date(Timestamp(UPDATED,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm') -

date(Timestamp(CREATED,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm'),'hh:mm') AS mins_difference,

can anyone help with the correct syntax please?

vvira1316 — Fri, 22 Sep 2017 18:37:15 GMT

Hi Phil,

Sample Data/App may help to help you.

BR,

Vijay

vishsaggi — Fri, 22 Sep 2017 18:43:26 GMT

May be try this?

Interval(

date(Timestamp#(UPDATED,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm') -

date(Timestamp#(CREATED,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm'),'hh:mm') AS mins_difference,

shraddha_g — Sat, 23 Sep 2017 03:38:47 GMT

minute(

interval(Timestamp(UPDATED,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm') -

Timestamp(CREATED,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm'),'hh:mm:Ss')

)

sujeetsingh — Sat, 23 Sep 2017 05:16:33 GMT

Use Interval function to calculate the date difference. Well plz check the format of both date fields it should not be string.

Anonymous — Mon, 25 Sep 2017 16:33:01 GMT

You can use an expression like it.

I created the inline table just for this example.

[tab1]:

LOAD

Interval( end - start, 'mm' ) AS [Minutes]

;

[tab2]:

LOAD

INLINE

[

start, end

'20/06/2017 13:45:00', '23/06/2017 16:00:00'

]

;