topic Re: Shift for every calendarweek in QlikView

Shift for every calendarweek

MoritzvdM — Sat, 16 Nov 2024 18:10:46 GMT

Hi guys,

I have a startdate/ startcalendarweek for every shift for every employee. E. g. employee "1196" did start in CalendarWeek 28 with shift 3, which is the nightshift. In week 29, he is in shift 1, which is the middle shift. In week 30, he is in shift 2, which is the morning shift... and so on.

My problem is that I only have the startcalendarweek and the related shift in week 28 for this employee, but I want to plan the shifts until the end of 2021. So I need a loop (?) for the weeks after week 28. I do not know how to solve the problem in the script.

Furthermore there is not only this one employee, there are more employees that have different calendarstartweeks and startshifts.

Do you guys please have a solution for me?

Thank you very much in advance.

Kind regards,

Moritz

Re: Shift for every calendarweek

Brett_Bleess — Tue, 08 Sep 2020 21:08:04 GMT

Best I have is the Design Blog area of Community:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Try searching on 'calendar' for starters and check out some of those results to see if anything there may get you on the right track, feel free to try other key words after that to see if you can find other posts that may be helpful.

Regards,
Brett

Re: Shift for every calendarweek

Kushal_Chawda — Tue, 08 Sep 2020 22:13:25 GMT

@MoritzvdM what is the expected output for employee 1196?