topic datetime - a few seconds in QlikView

datetime - a few seconds

amien — Sun, 06 Dec 2009 17:41:16 GMT

i have this in a pivot:

datetime, date(datetime), time(datetime)

what i want another expression .. same as time(datetime) .. but with a few seconds less

something like 'time(datetime - workloadtime)'

where werkloadtime is a few seconds .. 20, 45, 110 etc etc.

cant get it working with NUM 😞

Thaks in advanced

datetime - a few seconds

Sun, 06 Dec 2009 20:44:34 GMT

Amien,

I am using QV 9 Sr2 and when I perfrom the calculation you mention in a pivot table it works as expected:

So no use for num here I think 🙂

Regards, Jan

datetime - a few seconds

amien — Sun, 06 Dec 2009 22:11:04 GMT

Thanks for your reply..

timestamp comes from a datetime field using time(datetime) .. so that works .. the problem is that timpstamp2 comes not from a datetime stamp but is really an integer what contains seconds.

i need:

time(timestamp1 - 20)

where 20 is 20 seconds

datetime - a few seconds

Sun, 06 Dec 2009 22:43:10 GMT

That is no problem. Just transform the seconds into a number like

time(timestamp1 - (workedseconds/(60*60*24)))

Hope this works for you