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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dates substruction issue

Please guys I need your help.

If I choose the day D, I need an expression that allows me to calculation the production between D 05:59:57 and D+1 05:59:57

Example:

If I choose the date 06/06/2016, I should have the production between the day 06/06/2016  05:59:57 and 07/06/2016  05:59:57.

Thank you.

Labels (1)
11 Replies
Not applicable
Author

Kaushik I tried to send it to you, but I couldn't the file is heavy or something

Here is a picture of Timestamp I have in my database.

thank you soo muchCapture1.PNG

Not applicable
Author

Kaushik, Is there any other way where I can send you the sample data please ????