Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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