topic Help generating missing data in QlikView

Help generating missing data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Help generating missing data

qlikviewwizard — Tue, 10 Jul 2018 09:11:52 GMT

Hi,

Try this. How to populate a sparsely populated field

Re: Help generating missing data

pooja_prabhu_n — Tue, 10 Jul 2018 09:59:20 GMT

Hi,

Please refer the attached qvw file.

Re: Help generating missing data

Anonymous — Tue, 10 Jul 2018 13:55:08 GMT

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?