Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

convert to duration..

.

4 Replies
Highlighted
Master III
Master III

is this the data in the column ?

Highlighted
Creator III
Creator III

.

Highlighted
Master II
Master II

what is your expected output?

Highlighted
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

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