Percentile Range

alexismerinocue — Thu, 22 Jan 2015 16:24:59 GMT

Hi everybody,

How can I calculate the percentile range for an employee? Due to his category, month and year. I mean, I have the next calculation for percentile,

num(fractile(aggr(sum({<Ejercicio=p(Ejercicio),[Mes Contable]={'<=$(vMesActual)'}>}[Salario Actual]) / ($(mNumeroEmpleadosEvolucion)),[Categoría Profesional],Empleado_id,Ejercicio,[Mes Contable]),$(vValorPercentil)),'#.##0'))

Where $(vValorPercentil) is an input field to calculate the percentile.

But now the customer wants to calculate what is the range percentile for this employee acording with his category, for example if the salary of this employee is 33.500 and the salaries of the rest of employees with the same category are 32.000, 48.500, 33.500, 40.000 the range percentile is 33,3.

Any help?

Regards

Re: Percentile Range

Gysbert_Wassenaar — Fri, 23 Jan 2015 11:56:12 GMT

Add the category to the set modifier in both the sum and the fractile aggregation functions.

topic Re: Percentile Range in QlikView

Percentile Range

Re: Percentile Range