Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
shivani_singhal
Partner - Contributor III
Partner - Contributor III

How to deal with special calendar where week is starting from Tuesday 9:00 AM?

Hi,

I have an issue in making calendar where my week is starting from Tuesday 09:00:00 and ending with Tuesday 08:59:59. 1 day have two dates. And when I select one date suppose 5th July, the I must find the records between 5th July 09:00:00 to 6th July 08:59:59.

Also I have two shifts (one is morning i.e. 09:00:00 to 20:59:59 and other is evening i.e. 21:00:00 to next day 08:59:59). 

Please help me out to deal with this issue.

2 Solutions

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Hi ,

For week start from Tuesday

SET FirstWeekDay=1;

For the Timing, I will send you a sample file shortly.

View solution in original post

mdmukramali
Specialist III
Specialist III

Hi,

for the day start from 9:00:00 use the below code:

Date(Floor(Timestamp((TimeStamp) - 9/24))) as NewDate,




Day Start Time.PNG

kindly find the attached sample application also.

Thanks,

Mohammed Mukram

View solution in original post

7 Replies
mdmukramali
Specialist III
Specialist III

Hi ,

For week start from Tuesday

SET FirstWeekDay=1;

For the Timing, I will send you a sample file shortly.

mdmukramali
Specialist III
Specialist III

Hi,

for the day start from 9:00:00 use the below code:

Date(Floor(Timestamp((TimeStamp) - 9/24))) as NewDate,




Day Start Time.PNG

kindly find the attached sample application also.

Thanks,

Mohammed Mukram

shivani_singhal
Partner - Contributor III
Partner - Contributor III
Author

Thanks for the query.:)

shivani_singhal
Partner - Contributor III
Partner - Contributor III
Author

Hi,

Can you attach the .qvw file also.

mdmukramali
Specialist III
Specialist III

I have already attached the QvW.

shivani_singhal
Partner - Contributor III
Partner - Contributor III
Author

No application is attached with your reply.

Please attach the file once again.

Thanks,

Shivani

shivani_singhal
Partner - Contributor III
Partner - Contributor III
Author

I got the application.

Thanks.