Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi I was trying to find a solution to this too . Were you able to fix this?
I would also like a solution to this, as I am running ino the same problem...
Try this
avg(total aggr(Fractile(Total <Department> Age,0.8), Department))
=
Fractile(total aggr(sum(Age),Department,Rk_dep),0.8)
Does any one resolve this question, i was looking for this answer.
Regards,
Satish