topic Re: Transform to Time in QlikView

Transform to Time

pgalvezt — Mon, 05 Mar 2012 21:56:19 GMT

Hi! Please I need your help, I would like to transform my formula to time hh:mm:ss. I've tried with time, Interval and TimeStamp, but its not working. I´ve attached my qv file.

Thanks!

Transform to Time

Anonymous — Mon, 05 Mar 2012 22:43:09 GMT

Hi,

what is the field name that you are trying to convert?

Transform to Time

pgalvezt — Tue, 06 Mar 2012 12:11:24 GMT

Hi,

The Expression is (SumOfSum_DiferenciaCL/60) & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60). And this I need to pass To Time. For example: Sumof sum 18 that number I have to convert to time. In my Excel file I have: =INT(C2/60)&":"&INT(((C2/60)-INT(C2/60))*60),

so the number 18 is converted to 0:18.

Transform to Time

CELAMBARASAN — Tue, 06 Mar 2012 12:15:16 GMT

Hi,

Did you tried with Time#?

Time#(SumOfSum_DiferenciaCL/60) & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60,'h:m')

Hope it helps

Celambarasan

Transform to Time

pgalvezt — Tue, 06 Mar 2012 12:39:46 GMT

Hi, thanks for your reply but Still is not working

Time#(SumOfSum_DiferenciaCL/60,'h:m') & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60).

Transform to Time

CELAMBARASAN — Tue, 06 Mar 2012 12:42:38 GMT

Hi,

Paranthesis problem in previous post check the below expression.

Time#((SumOfSum_DiferenciaCL/60) & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60),'h:m')

Celambarasan

Re: Transform to Time

pgalvezt — Tue, 06 Mar 2012 12:52:42 GMT

Hi, Still not working. I´ve tried with format number but nothing happened.

Re: Transform to Time

pgalvezt — Tue, 06 Mar 2012 13:07:46 GMT

Any help?

Thanks!

Re: Transform to Time

CELAMBARASAN — Tue, 06 Mar 2012 13:15:25 GMT

I think it returns decimal values.

Check with this

Time#(Floor(SumOfSum_DiferenciaCL/60) & ':'& Floor((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60),'h:m')

Hope it helps

Celambarasan

Re: Transform to Time

pgalvezt — Tue, 06 Mar 2012 13:36:50 GMT

Thank you for your reply. Almost ready. but I think is not working yet. The idea is emule the excel file. I´ve attached the excel file for better comprehenssion.

Thanks

Re: Transform to Time

CELAMBARASAN — Tue, 06 Mar 2012 13:40:22 GMT

Hi,

Try with this using mod function

Time#(Floor(SumOfSum_DiferenciaCL/60) & ':'& Mod(SumOfSum_DiferenciaCL,60),'h:m')

Celambarasan

Re: Transform to Time

pgalvezt — Tue, 06 Mar 2012 14:09:43 GMT

Finally works many thanks!