Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
klausskalts
Partner - Creator
Partner - Creator

Fractile - caluclated over values in a dimension

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 ?

5 Replies
Not applicable

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

Not applicable

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

Clever_Anjos
Employee
Employee

Try this

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

Not applicable

=

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

Not applicable

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

Regards,

Satish