Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help generating missing data

Assuming I have the following table:

Activity_IDDateTime_Period
Fraction
104-06-2018Until 110.25
204-06-201811 to 140.25
305-06-2018Until 140.5
405-06-2018After 140.5
507-06-2018Until 110.25
608-06-2018Whole 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)

3 Replies
qlikviewwizard
Master II
Master II

pooja_prabhu_n
Creator III
Creator III

Hi,

Please refer the attached qvw file.

Capture.PNG

Anonymous
Not applicable
Author

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?