Help generating missing data

[Anonymous]

Assuming I have the following table:

Activity_ID	Date	Time_Period	Fraction
1	04-06-2018	Until 11	0.25
2	04-06-2018	11 to 14	0.25
3	05-06-2018	Until 14	0.5
4	05-06-2018	After 14	0.5
5	07-06-2018	Until 11	0.25
6	08-06-2018	Whole day	1

I need to generate and sum the Fraction of the dates that are left uncompleted. A date is considered uncompleted if the sum of Fraction for a single date is less than 1. I also have to consider the dates that don't have any activities at all when calculating the sum.
In this example that Sum would be 0.5(missing from 04-06-2018) + 1(the date 06-06-2018, doesn't have any activities) + 0.75(missing from 07-06-2018)

[qlikviewwizard]

Hi,

Try this. How to populate a sparsely populated field

[pooja_prabhu_n]

Hi,

Please refer the attached qvw file.

[Anonymous]

So assuming I have multiple employees and I generate the table for all of them(say add a new column called "Employee_ID"), how can I calculate the Sum(Fraction) for each employee assuming the Employees are the Dimensions?