Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

'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
Anonymous
Not applicable
Author

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
sunny_talwar

May be this

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

Anonymous
Not applicable
Author

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.