This content has been marked as final. Show 5 replies
I need to be able to calculate average age of the 20% oldest instances - department by department.
I have created this formula:
aggr(avg(aggr(Fractile(Total <Department> Age,0.8), Department)), Department)
Which have this problem:
This returns the correct value - department by department - however only for one row in the chart.
I would like to have the formula return the correct value for all rows in the chart.
The QlikView file is attached ....
Any ideas ?