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 ?