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

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

shivani_singhal — Wed, 25 Jul 2018 04:57:56 GMT

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.

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

mdmukramali — Wed, 25 Jul 2018 05:22:28 GMT

Hi ,

For week start from Tuesday

SET FirstWeekDay=1;

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

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

mdmukramali — Wed, 25 Jul 2018 06:19:12 GMT

Hi,

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

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

kindly find the attached sample application also.

Thanks,

Mohammed Mukram

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

shivani_singhal — Wed, 25 Jul 2018 06:43:26 GMT

Thanks for the query.:)

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

shivani_singhal — Wed, 25 Jul 2018 06:45:02 GMT

Hi,

Can you attach the .qvw file also.

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

mdmukramali — Wed, 25 Jul 2018 06:46:40 GMT

I have already attached the QvW.

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

shivani_singhal — Wed, 25 Jul 2018 06:49:49 GMT

No application is attached with your reply.

Please attach the file once again.

Thanks,

Shivani

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

shivani_singhal — Wed, 25 Jul 2018 06:56:09 GMT

I got the application.

Thanks.