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: 
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 III
Creator III

Hi @Paknanarn23 ,

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

Regards.