topic Time from TimeStamp in QlikView

Time from TimeStamp

manojkulkarni — Mon, 06 Apr 2015 06:21:11 GMT

Hi everyone,

How to get hour part from given timestamp ? Hour should get round of to nearest value.

eg :01:35:21 -> "02"

00:21:45 -> 00

Re: Time from TimeStamp

Anonymous — Mon, 06 Apr 2015 06:24:51 GMT

=Date(now(),'HH')

this is for current hour

you can use =Date(yourfield/varibalename,'HH')

Re: Time from TimeStamp

Anonymous — Mon, 06 Apr 2015 06:25:57 GMT

if your varibale/field in some other format

then

Date(Date#(yourfield/varibalename,'Original DDMMYYY etc format'), 'HH')

Re: Time from TimeStamp

manojkulkarni — Mon, 06 Apr 2015 06:26:13 GMT

what is the use of variablename ?

Re: Time from TimeStamp

Anonymous — Mon, 06 Apr 2015 06:28:32 GMT

if your time stamp is saved in variable then put variable name else if it is in field then use field name

Re: Time from TimeStamp

Anonymous — Mon, 06 Apr 2015 06:29:03 GMT

best way is upload sample application

Re: Time from TimeStamp

manojkulkarni — Mon, 06 Apr 2015 06:33:21 GMT

i have column having timestamp alone, i would like to take only hour part of it.

This is required to do hourly analysis.

below are the possible values .

01:51:00

01:52:00

01:53:00

01:53:38

01:53:48

01:54:00

01:54:24

01:54:48

01:55:00

01:55:07

01:55:29

01:56:00

01:56:20

01:56:40

01:56:44

01:57:00

01:57:57

Re: Time from TimeStamp

Mon, 06 Apr 2015 06:34:10 GMT

if(minute(Datetime)>=35,hour(Datetime)+1,hour(Datetime))

Re: Time from TimeStamp

anbu1984 — Mon, 06 Apr 2015 06:42:02 GMT

=SubField('01:35:21',':',1) + If(SubField('01:35:21',':',2)>=30,1,0)

Re: Time from TimeStamp

Anonymous — Mon, 06 Apr 2015 06:42:57 GMT

use this

Date(Date#(ColumnName,'HH:MM:SS'), 'HH')

Re: Time from TimeStamp

its_anandrjs — Mon, 06 Apr 2015 07:33:50 GMT

Hi,

Let me know this formats are in the HH:MMSS.

Regards

Anand

Re: Time from TimeStamp

its_anandrjs — Mon, 06 Apr 2015 07:36:49 GMT

Hi.

If is is then do some thing this way

Time( Left([Column Name],2), 'hh')

Time(Time#( Left([Column Name],2), 'hh'),'hh')

Regards

Anand