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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SR2210
Contributor
Contributor

Add time fields coming from source

Hi,

 

I would like to know how we can do adding operation/ expression in tmap for time.

 

 

example : 1st value im receiving is : 08:00:01 (HH:mm:ss)

0683p000009M8wU.jpg

 

 

 

the next value is : 02:01:06 (HH:mm:ss)

 

My output should be :

0683p000009M8wZ.jpg

 

 

10:01:07 (HH:mm:ss) -updated in the same row

Thanks in advance. 0683p000009MACn.png 

Labels (2)
1 Reply
akumar2301
Specialist II
Specialist II

Hello

There are many ways to do it.
One idea is
to convert duration to seconds add value by t aggregaterow

And the convert back in hh:mm:ss format.