Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Not applicable

Converting hour to minutes

Hi,

I've a runtime field as EndtimeStamp - StarttimeStamp; by the Interval(Runtime, 'hh') I retrieve the runtime hours.

Now I would convert this value into minutes. I thought to do  hours * 60 , but it doesn't work, because the system is showing wrong values.

What I'm making wrong ?

Help !!

1 Solution

Accepted Solutions
celambarasan
Not applicable

Re: Converting hour to minutes

HI

Try

=num#(text(Interval(Runtime, 'hh')))*60

4 Replies
celambarasan
Not applicable

Re: Converting hour to minutes

HI

Try

=num#(text(Interval(Runtime, 'hh')))*60

bibopipo
Not applicable

Re: Converting hour to minutes

Great !!!

Thanks again !!

Just one thing: which is the difference between  num  and num# ?

celambarasan
Not applicable

Re: Converting hour to minutes

Num is to format the number values in to desired number format.

Num# is to convert string to number and also in some cases you need to mention the format of the input given to it.

Example

Num(1234567, '$#,###') results $1,234,567

Num#('$2,345.45','$#,###.##')

bibopipo
Not applicable

Re: Converting hour to minutes

Thanks!!