Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Contributor III
Contributor III

replacing a char with another char

Hi all,

couldnt find a solution that helped me.

In the following expression :

left(num(sum(TotalPause)*24,'0.00'),1) &':'&
round(right(num(sum(TotalPause)*24,'0.00'),2) *60/100,'0.01')

 

I need to replace the '.' with a ':'  

so for example the 3rd value will look like: 

3:51:00

 

what is a proper solution? 

thanks 

Alon

 

aheavy95_0-1664376704877.png

 


I need to replace 

Labels (3)
2 Replies
BrunPierre
Specialist II
Specialist II

Like this perhaps

Time(Time#(left(num(sum(Value)*24,'0.00'),1) &':'&round(right(num(sum(Value)*24,'0.00'),2) *60/100,'0.01'),'hh:mm.ss'),'hh:mm:ss')

MarcoWedel

So you are trying to sum intervals and display the result in a specific format?