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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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