Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
tappij2012
New Contributor II

Convert calculated number to time

Hi,

I want to convert a calculated number  into a time-format in a table.

For Example:

I've calculated a number: 128, which means 128 minutes.

In time-format it will be: 02:08 [hh:mm].

How can I make that work?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Convert calculated number to time

=Time(Time#(Num#('128','#0'),'m'),'hh:mm')

View solution in original post

5 Replies
MVP
MVP

Re: Convert calculated number to time

=Time(Time#(Num#('128','#0'),'m'),'hh:mm')

View solution in original post

Re: Convert calculated number to time

Hi,

You can convert this way

Load

Time( Time#( num(NumberField),'m'),'hh:mm') as NUmField

From Location;

Ex:- any any text box write this expression

=Time( Time#( num('128'),'m'),'hh:mm')

Regards

Anand

tappij2012
New Contributor II

Re: Convert calculated number to time

Now I've seen that it count until 23:59 [hh:mm].

After that it counts from 0.

For example:

number 1439 give as result 23:59 [hh:mm]
number 1441 give as result 00:01 [hh:mm] (and not like I wish 24:01 [hh:mm])

How can I solve that?

Regards Robin

anbu1984
Honored Contributor III

Re: Convert calculated number to time

=Floor(1441/60) & ':' & Num(Mod(1441,60),'00')

MVP
MVP

Re: Convert calculated number to time

=interval(1441/1440,'hh:mm')