Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.

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 ????