https://community.qlik.com/t5/QlikView/calculate-worktime-from-scheme/m-p/1603238#M444493 <P>Hi,</P><P>Working on a HR-app, and have hit a bump on the road so to speak. Tried finding anything here but not sure what to search for.</P><P>I need to figure out how many hours my staff is supposed to work over time. Ive got these tables to help me;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TableViewer" style="width: 560px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/15587iE72888B5335C376F/image-size/large?v=v2&amp;px=999" role="button" title="Scheme.PNG" alt="TableViewer" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">TableViewer</span></span><BR /><BR /></P><P>As you can see in the demo, staff can alternate workinghours within one scheme.<BR />Is there a way to populate a table with certain dates so that I can show the answer;&nbsp;"Arnold should work 170h in may"??</P><P>Thanks in advance for any help!</P> Sat, 16 Nov 2024 20:26:13 GMT t_hylander 2024-11-16T20:26:13Z https://community.qlik.com/t5/QlikView/calculate-worktime-from-scheme/m-p/1603238#M444493 <P>Hi,</P><P>Working on a HR-app, and have hit a bump on the road so to speak. Tried finding anything here but not sure what to search for.</P><P>I need to figure out how many hours my staff is supposed to work over time. Ive got these tables to help me;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TableViewer" style="width: 560px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/15587iE72888B5335C376F/image-size/large?v=v2&amp;px=999" role="button" title="Scheme.PNG" alt="TableViewer" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">TableViewer</span></span><BR /><BR /></P><P>As you can see in the demo, staff can alternate workinghours within one scheme.<BR />Is there a way to populate a table with certain dates so that I can show the answer;&nbsp;"Arnold should work 170h in may"??</P><P>Thanks in advance for any help!</P> Sat, 16 Nov 2024 20:26:13 GMT https://community.qlik.com/t5/QlikView/calculate-worktime-from-scheme/m-p/1603238#M444493 t_hylander 2024-11-16T20:26:13Z https://community.qlik.com/t5/QlikView/calculate-worktime-from-scheme/m-p/1611683#M445190 <P>Well, I do not know if the following is going to be on the right track or not, but it gets you to the Design Blob area where you may be able to find some further examples etc. that could help.</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467840" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467840</A></P> <P>Hopefully this may give you some ideas.</P> <P>Regards,<BR />Brett</P> Mon, 12 Aug 2019 15:57:44 GMT https://community.qlik.com/t5/QlikView/calculate-worktime-from-scheme/m-p/1611683#M445190 Brett_Bleess 2019-08-12T15:57:44Z