Qlik Sense Count rows on different Table

[LeHaoNguyen]

Hello Qlik Users,

i got a picture of my datamodel and cant figure  out how to solve the following problem:

I got a table "Tasks"(Aufgaben) where there is an "user"(Bearbeiter), a "startdate"(Bearbeitungsstart) and an "enddate"(Fälligkeitszeit) using intervalmatch to bind it with a mastercalendar.

But now i also got a "Timerecordings" table with an "user"(Bearbeiter) which should also be in the "Tasks"(Aufgaben) table so they are connected.

Now i want to count the number of entries in "Timerecordings" for every row in "Tasks". The Row needs to be counted when:

A) its the same "user"(Bearbeiter)

B) when the "Startworkday" is between the "startdate"(Bearbeitungsstart) and "enddate"(Fälligkeitszeit) of the task

can i somehow do this in loadscript and add it as a Column in the Tasks table as CountedWorkdays?