Interval Match Help In Qlik Sense

[h_prakash]

Hi Qlik Experts,

I have the Following Data Like this

   IntervalTable: 

Project	Name	Start Dt	End Dt	Hr Per day
1	john	1/1/2015	5/31/2018	4
1	Daniel	3/31/2016	9/30/2018	7

In the front end When a user select 2017 he wants to see how many hours John has or Daniel has.

This is Just a sample Data. In reality we have many rows in the above table.

I tried to use while loop generating dates between Start Dt and End Dt but it is taking more time to complete the load.

I see other option as interval match.

I tried like this

BridgeTable:

IntervalMatch (Dates)

Load Start Dt,

         End Dt

Resident IntervalTable;

Dates field is coming from Master Calender.

But When I tried to create a KPI to sum of the Hrsperday in the year 2017 I am getting Calculation error.

The Expression is like this. Sum(Aggr(Sum(Hr Per Day), Project, Name, Dates))

Please help..!!

[h_prakash]

Thank you kaan for resonding. I think I found the solution.