Fractile - caluclated over values in a dimension

[klausskalts]

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 ?

[#2]

Hi I was trying to find a solution to this too . Were you able to fix this?

[#3]

I would also like a solution to this, as I am running ino the same problem...

[Clever_Anjos]

Try this

avg(total aggr(Fractile(Total <Department> Age,0.8), Department))

[#5]

=

Fractile(total aggr(sum(Age),Department,Rk_dep),0.8)

[#6]

Does any one resolve this question, i was looking for this answer.

Regards,

Satish