Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lukas_ignatavic
New Contributor II

Time counting in hierarchy

Hello,

I have data like this:

IDTitleEstimateActualParentother fields...
1A1012
2B510

1

3C52

1

4D352
5E252

I need to get statistics on Estimate and Actual and the issue is that data is already calculated up. 4 and 5 task times sum is in task 2 and 2 and 3 is in task so if I am filtering by other fields and using sum(actual)-sum(estimate) I am getting wrong results. How could I solve this?

Community Browser