topic Re: Quartile in QlikView

Quartile

Tue, 28 Apr 2015 17:52:29 GMT

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

Re: Quartile

sunny_talwar — Tue, 28 Apr 2015 18:21:51 GMT

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

Re: Quartile

Tue, 28 Apr 2015 19:32:31 GMT

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

Re: Quartile

JonnyPoole — Tue, 28 Apr 2015 19:49:06 GMT

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.

Re: Quartile

Clever_Anjos — Tue, 28 Apr 2015 20:05:07 GMT

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

Re: Quartile

Tue, 28 Apr 2015 20:44:54 GMT

thanks jonathan poole, i will test with round()

Re: Quartile

Tue, 28 Apr 2015 20:51:09 GMT

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