topic Re: Query on time function in QlikView

Query on time function

hopkinsc — Fri, 14 Oct 2011 08:34:06 GMT

Hi, i am trying to display a time field properly as a dimension, my data for this field is in the following format..

093025

which is the correct format but its missing the colons (09:30:25)

How do i insert the colons? i have tried but all i am getting is 00:00:00..

Thanks

its_anandrjs — Fri, 14 Oct 2011 08:38:44 GMT

Hi,

Use time stamp function

Rgds

Anand

SunilChauhan — Fri, 14 Oct 2011 08:40:53 GMT

left(fieldname,2)&':'&mid(fieldname,3,2)&':'&right(fieldname,2) as Newfield name in script

or you can use in expression also

hopkinsc — Fri, 14 Oct 2011 08:47:17 GMT

TimeStamp function returns 00:00:00

Thanks Sunil, i have used your suggestion in an expression.

its_anandrjs — Fri, 14 Oct 2011 08:59:15 GMT

Hi,

See how the time stamp is used by below example

Raw:

load * inline

[

COl

093025

];

Data:

Load

left(COl,2) as HH,

mid(COl,3,2) as MM,

Right(COl,2) as SS,

Timestamp#((left(COl,2) &':'& mid(COl,3,2) &':'& Right(COl,2) ),'HH:MM:SS') as a

Resident Raw;

See the sample file

Rgds

Anand

its_anandrjs — Fri, 14 Oct 2011 16:47:27 GMT

Hi,

Can you check it my way hope you got it if so mark it correct or helpful answer.

Rgds

Anand