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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rmendoza
Contributor II
Contributor II

Qlik Sense - Substract Timestamp

Hello everyone

When I subtract two dates, I want to mark them as being under 15 minutes apart. How can I do this? Thanks.

 

rmendoza_0-1750945725124.png

Cheers 

Renzo

Labels (1)
1 Solution

Accepted Solutions
MatheusC
Specialist II
Specialist II

@rmendoza 
Do you want to indicate those whose difference is less than 15 minutes?

If([Your difference between dates] <= 15 / (24 * 60), '< 15 min', '>15 min')

- Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

2 Replies
MatheusC
Specialist II
Specialist II

@rmendoza 
Do you want to indicate those whose difference is less than 15 minutes?

If([Your difference between dates] <= 15 / (24 * 60), '< 15 min', '>15 min')

- Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
rmendoza
Contributor II
Contributor II
Author

@MatheusC Merci !

 

Cheers

Renzo