Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert value from timestamp into int and increase value

Goal:

Display value in hours as integer after completed calculation that is (answer = end - begin),

Problem:

After doing calculation you gain the result based on the sourcecode below. Some example of result is:

02:54

04:35

65:25

25:15

I need to make the value to become:

Current data       Requested result

-----------------------------------------------------

02:54            >   03 or 3

04:35            >   05 or 5

65:29            >   65

25:15            >   25

123:32          >   124

The main problem is

I don't know how to do it based on the source code below.

If the number is higher than 29 the result will be increase with one value   (12:30 wil be 13)

BeginEnd
2011-11-10 12:12:122011-11-12 12:12:12
2011-11-10 12:12:122011-11-11 08:12:12

(The column Begin and End have timestamp as number format settings in doucment settings)

The source code is

INTERVAL

(

     End - Begin

     , 'hh:mm'

)

or

INTERVAL

(

     End - Begin

     , 'mm'

)

// JJ

0 Replies