Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I don't want negative data to be displayed. What should I do?

Hi, I don't want times with negative values ​​displayed in the table.

Paknanarn23_1-1695711192711.png

 

Paknanarn23_0-1695711148130.png


This is my code

What I want is to subtract the time in the TimeStamp field by row2 - row1 and row3 - row2 and so on. What should I do?

 

1 Reply
sbaro_bd
Creator
Creator

Hi @Paknanarn23 ,

You can use Sign() function to encapsulate your expression :  IF( Sign(your_expression)=-1, null(), your_expression) as [Turnover Time].

Regards.