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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.