Quartile

[#1]

Hello,,,

I'm trying to make a Quartile productivity of employees, ordered by notes of High-Low, but it does not know how to divide this quartile in 4 equal parts.

someone could give me a hand, I'm posting an example in excel.

ps: sorry for my bad english

[sunny_talwar]

What exactly is your question? Do you want to know how to calculated Quartile in QlikView?

[#3]

Yes, it's basically dividing a column in 4 equal parts

[JonnyPoole · Accepted solution]

Here is an example.

I noticed that your quartile are not by the rank of the employee by the numbers, but by the row order in your spreadsheet.

So first quartile is:  

avg(  {<EmployeeNumber={"<=$(=count(total distinct EmployeeNumber)/4*1)"}>}  Data)

2nd quartile is:

avg(  {<EmployeeNumber={">$(=count(total distinct EmployeeNumber)/4*1)<=$(=count(total distinct EmployeeNumber)/4*2)"}>}  Data)

3rd quartile is:

avg(  {<EmployeeNumber={">$(=count(total distinct EmployeeNumber)/4*2)<=$(=count(total distinct EmployeeNumber)/4*3)"}>}  Data)

4th quartile is:

avg(  {<EmployeeNumber={">$(=count(total distinct EmployeeNumber)/4*3)<=$(=count(total distinct EmployeeNumber)/4*4)"}>}  Data)

... BUT  you may need some round() , floor() or ceil() functions to delineate the boundaries properly when number of employees is not divisible by 4.

[Clever_Anjos]

I think that Fractile() is the function you need, using 0.25, 0.5 and 0.75 as parameters

Please check your manual for proper usage

[#6]

thanks jonathan poole, i will test with round()

[#7]

I've tested it with fractile, but are of different sizes quartiles