Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srinivasa1
Contributor II

hour

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

25

81

128

152

Pls  guide why my hour function is not working

thanks in adavance.

4 Replies

Re: hour

HI

Try like this:

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

hope it helps

Re: hour

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
Contributor II

Re: hour

Hi

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

Thanks

srinivasa1
Contributor II

Re: hour

Thanks. Sorry  i made mistake now i got it correct

thanks to all