Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.