topic Re: Creating a shift pattern flag in QlikView

Creating a shift pattern flag

rustyfishbones — Fri, 17 Aug 2018 13:05:10 GMT

Hi,

I need to create a flag for different shift patterns, one shift happens across 2 days, 6pm on day 1 to 6am on day 2.

I have a calandar obects and input parameters for the times like this

However, the above selection would give me data for a full shift and half of the next shift.

So.....

from 18:00 to 00:00 on the 02/07/2018 - 00:01 to 05:00 on 03/07/2018 but also 18:00 to 00:00 on the 03/07/2018

I want to create a flag of some sort that I can select it so it does not include the part in Bold

Any ideas.

Re: Creating a shift pattern flag

petter — Fri, 17 Aug 2018 13:14:46 GMT

The InDay() function can take a "shift" parameter making it easy to create a flag in your load script that you can check against in your expression with a simple "set expression":

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/inday.htm

Re: Creating a shift pattern flag

rustyfishbones — Fri, 17 Aug 2018 13:39:57 GMT

Thanks Petter,

But my Dates and Times are in Seperate fields.

Regards

Alan

Re: Creating a shift pattern flag

petter — Fri, 17 Aug 2018 13:54:40 GMT

It is easy to add them up (a simple addition) and then use the InDay() function as the date part is an integer and the time is a fraction.

Re: Creating a shift pattern flag

rustyfishbones — Fri, 17 Aug 2018 14:01:17 GMT

Yes, I have combined the fields together using a preceding load, and I have tried the InDay function, at the moment with very little joy.

I'll keep at it.

Re: Creating a shift pattern flag

rustyfishbones — Fri, 17 Aug 2018 15:39:25 GMT

Still no Joy, can anyone else help?

Re: Creating a shift pattern flag

petter — Sun, 19 Aug 2018 04:31:59 GMT

It will be easier for you to get help and much easier for us to help you if you have a small sample dataset and/or an application that shows your issue...