topic Re: 'Other' in dimension limit is grouping all values. in QlikView

'Other' in dimension limit is grouping all values.

Anonymous — Mon, 06 Nov 2017 14:53:15 GMT

Hi all,

I have an issue where i am taking sum of total working hours of all employees and dividing it with actual working hours per month.

Sum(actual working hours for Jan 2017) = 184, for Feb it's 168 for Mar it's 184.

My expression says : sum(working hours)/ sum(aggr(sum distinct actual_hours),Area,Month)

The 'Other' value is showing wrong, it should be 15 but it's showing 9. Please see the attached qvw.

Re: 'Other' in dimension limit is grouping all values.

sunny_talwar — Mon, 06 Nov 2017 15:05:56 GMT

May be this

Sum(Working_Hours)/If(Len(Trim(Area)) = 0, Sum(Aggr(hours, Month)), Sum(hours))

Re: 'Other' in dimension limit is grouping all values.

Anonymous — Tue, 07 Nov 2017 09:45:14 GMT

Thanks for the reply Sunny, but my requirement says that i should consider all month irrespective of whether data is present for that month or not. So what i did is i stored this value

sum(aggr(sum(hours),Month)) into a variable and then used this variable in chart expression.