5 Replies Latest reply: Jul 25, 2014 7:54 AM by Satish Amarapalli RSS

    Fractile - caluclated over values in a dimension

    klaus skalts

      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 ?