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..!!
