Qlik Community

Qlik Sense Cloud Discussions

Highlighted
Partner
Partner

Same measure based on different dimensions gives different results in charts

Hi,

I have a measure called number of working days which gives me different values in different dimensions.One dimension is the period and the other dimension is employeeEmail. It gives me the correct result in Period dimension.

When I filter it with each month individually then the values are correct in both the dimensions.

varNoOfWorkingDays : if(month(max(employeeActivityDate)) = month(Today()),
((NetWorkDays(monthstart(min(employeeActivityDate)),
monthend(max(employeeActivityDate))))-NetWorkDays(Today(),monthend(Today()))),
(NetWorkDays(monthstart(min(employeeActivityDate)),monthend(max(employeeActivityDate)))))

I am using the below expressions for each sheet respectively.

Sum(Aggr($(varNoOfWorkingDays),EmployeeEmail)) 

Sum(Aggr($(varNoOfWorkingDays),[Month Year]))


Employee.PNG.jpgPeriod.PNG