Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

'Other' in dimension limit is grouping all values.

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.

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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

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.

View solution in original post

2 Replies
Highlighted

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

May be this

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

Highlighted
Contributor III
Contributor III

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

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.

View solution in original post