topic Re: Time format in QlikView

Time format

Wed, 25 Mar 2015 10:47:28 GMT

Hi QV team,

These are actual dates.

400

450

600

645

730

1000

1200

1230

I require above dates like this.

00:00

04:00

04:50

06:00

06:45

07:30

10:00

12:00

12:30

Thanks,

Krish

Re: Time format

PrashantSangle — Wed, 25 Mar 2015 10:49:46 GMT

Hi,

Use Time(alt(Time#(FieldName,'mss'),(Time#(FieldName,'mmss')),'mm:ss')

Regards

Re: Time format

sunny_talwar — Wed, 25 Mar 2015 10:57:18 GMT

Are these Hours and Minutes or Minutes and Seconds??

Best,

Sunny

Re: Time format

Wed, 25 Mar 2015 11:13:54 GMT

Hi,

These are Hours and Minutes.

I did use this but it not work.

Time(Alt(Time#(Time,'hmm'),Time#(Time,'hhmm')),'hh:mm') as time

It is showing like this.

Re: Time format

PrashantSangle — Wed, 25 Mar 2015 11:20:14 GMT

Hi,

What do you mean by it not work???

Which value you are getting wrong??

Regards

Re: Time format

Wed, 25 Mar 2015 11:39:17 GMT

Hi Max,

This values are came correct.

400

450

600

645

730

These are not came correct.

1000

1200

1230

Re: Time format

PrashantSangle — Wed, 25 Mar 2015 12:30:17 GMT

Hi,

Well then try below

IF(LEN(TEST_TIME)=3,TIME(Time#(TEST_TIME,'hmm'),'hh:mm'),TIME(Time#(TEST_TIME,'hhmm'),'hh:mm'))

It will work for you

Regards

Re: Time format

sunilkumarqv — Wed, 25 Mar 2015 12:36:37 GMT

Time(Timestamp(

Alt(

Timestamp#([DateField],'DD/MM/YYYY hh:mm[:ss]'),

Timestamp#([DateField],'DD-MM-YYYY hh:mm[:ss]')

)

,'DD/MM/YYYY hh:mm'),'hh:mm') as Time

Re: Time format

Wed, 25 Mar 2015 12:43:20 GMT

Hi Sunil,

I am getting same problem.

Re: Time format

PrashantSangle — Wed, 25 Mar 2015 12:44:16 GMT

Hi,

did try my new suggestion.

Regards

Re: Time format

Wed, 25 Mar 2015 12:58:39 GMT

Hi Max,

I did try but did not get 00:00 instead of 0 date.

Re: Time format

Wed, 25 Mar 2015 13:04:45 GMT

Hello Naidu,

This may help to you

left(fieldname,2) & ':' & right(fieldname,2)

Thanks

Harsha

Re: Time format

Wed, 25 Mar 2015 13:05:59 GMT

Hello Naidu,

Correct it

num(left(fieldname,2),'00') & ':' & num(right(fieldname,2),'00')

Thanks

Harsha

Re: Time format

PrashantSangle — Wed, 25 Mar 2015 13:18:07 GMT

Hi,

add nested if() in provided solution.

IF(LEN(TEST_TIME)=3,TIME(Time#(TEST_TIME,'hmm'),'hh:mm'),if(LEN(TEST_TIME)=4,TIME(Time#(TEST_TIME,'hhmm'),'hh:mm'),TIME(Time#(TEST_TIME,'m'),'hh:mm')))

Regards

Re: Time format

Wed, 25 Mar 2015 13:46:12 GMT

Hi Max,

Thank you for gave correct answer.