Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Master II

Hi,

Creator III

Hi,

Please refer the attached qvw file.

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?

Community Browser