Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

convert to duration..

.

4 Replies
arulsettu
Master III
Master III

is this the data in the column ?

xyz1
Creator III
Creator III
Author

.

sushil353
Master II
Master II

what is your expected output?

girirajsinh
Creator III
Creator III

Here is the way you can approach.

convert all values to hours

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

create a MAPPING load like

working days, 7.5

office, 1

from SLA fields take out the Number Part and String part by using String functions

Use ApplyMap() and pass String Part to fetch related numbers

Multiply that with Number part i.e. 2*7.5 , 4*1 etc

Now you have total hours with decimal values

Use maketime() function to get desired output of HH:MM:SS

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