Aggregation not working

[TomBond77]

Hi experts

I have defined a KPI "Work hours", based on field "Date". The result below is fine:

If you remove field "Date" the result is like that:

Any thougths about this behaviour?

Thanks, Tom

[Or · Accepted solution]

Given that we do not know how the measure is defined, no thoughts in particular. Generally speaking, you need to make sure your aggregation level matches your dimension levels in a way that makes sense. If your aggregation returns one value per date, and there is no additional aggregation, then you will get more than one result per month and a null value in the eventual measure as Qlik does not know how to aggregate these results.

[TomBond77]

This is the formula:

networkdays ([Date], [Date])* Cap_H_D

[TomBond77]

fixed:

sum(networkdays ([Date], [Date])) * Cap_H_D