Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
t_hylander
Creator
Creator

calculate worktime from scheme

Hi,

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.

I need to figure out how many hours my staff is supposed to work over time. Ive got these tables to help me;

TableViewerTableViewer

As you can see in the demo, staff can alternate workinghours within one scheme.
Is there a way to populate a table with certain dates so that I can show the answer; "Arnold should work 170h in may"??

Thanks in advance for any help!

Labels (5)
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

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.

https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467...

Hopefully this may give you some ideas.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.