Discussion board where members can get started with QlikView.
I need to sum the amount of worked hours/day,in an expression, however if the amount of worked hours is above 8 hours, then the value is equal with 8.
the column headers are: Employee_ID, Date, Hours_Worked.
How should I use the aggr function inside a sum to get the results I need?
Then you need Aggr() to create an intermediate iterator. Try
View solution in original post
Try something like this: RangeMin(8, sum(Hours_Worked)).
Or perhaps sum(aggr(RangeMin(8, sum(Hours_Worked)), Employee_ID, Date))
If you want to show number of hours per day and employee, you should use Date and Employee_ID as dimensions, and
No need for an Aggr().
It seems to work for showing the number of worked hours per day per employee, but I need the sum of all the worked hours. Tried Sum(If(Sum(Hours_Worked)>8,8,Sum(Hours_Worked))) but I get an "Error in expression" message
That's it, thanks!