topic hour in QlikView

hour

srinivasa1 — Wed, 14 Nov 2012 21:52:02 GMT

Hi can any suggest me how i can find hours from below details

25:06:32 AM

81:00:18 AM

128:06:51 AM

152:59:36 AM

my result would look like

128

152

Pls guide why my hour function is not working

thanks in adavance.

MayilVahanan — Wed, 14 Nov 2012 21:54:50 GMT

Try like this:

=SubField('25:06:32',':')

hope it helps

CELAMBARASAN — Wed, 14 Nov 2012 22:19:27 GMT

Hi,

You can use hour function but only after formatting your data to the time format using Time#().

Here it still won't work because this is not in correct format 24 hr or 12 hr.

Its total time for more than 1 day. You can use

interval(interval#(Trim(Replace(Field,'AM','')),'hh:mm:ss'),'hh')

or simply go by mayil suggestion as

SubField(FieldName,':',1)

srinivasa1 — Thu, 15 Nov 2012 02:21:01 GMT

Thanks for reply.i need only 25 so i wll consider this 25 hrs.

Thanks

srinivasa1 — Thu, 15 Nov 2012 02:30:38 GMT

Thanks. Sorry i made mistake now i got it correct

thanks to all